0 Replies Latest reply on Apr 22, 2017 9:42 PM by priyankjayna



      Hi i have multiple clients data with following payment fields


      booking payment

      booking payment date

      booking payment method


      instalment payment

      instalment payment date

      instalment payment method


      balance payment

      balance payment date

      balance payment method


      each client can have multiple of booking, instalment and balance payment


      need to make chart showing the following

      Total payment from all clients on monthly / yearly basis (all of booking, quarterly, balance payments)

      Total Booking payment on Monthly / Yearly basis

      Total payment received by credit card Vs by cash on monthly / yearly basis



      have attached my fmp file here, As i am a novice please give me step to step guide to it