Discussion created by priyankjayna on Apr 22, 2017

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