Hi all ,
I'm using FM Pro Adv. 15 , Win (10).
on my solution i want to make something like dashboard to displays my actual numbers of my Invoices and the Planned and make a comparison between them with the Months of the year i'll filter or choose .
i have fields of Invoices Table
Invoices:: Business Field
on Planned table
i make a relationship between invoices::date & planned::date
i want to have 3 charts
1- to display the sum_amount of each month of any invoices::Business Field i will filter .
2- to display the sum_amount of each month of the year i filter or choose and make a comparison with planned::amount
3- to display the sum_amount of each planned::Business Field a comparison with Invoices:: Business Field
any advise appreciated .
Thanks in advance!