priyankjayna

Charting

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

Attachments

Outcomes