AnsweredAssumed Answered

Charts  Issue

Question asked by ibrahimn on Jun 20, 2017
Latest reply on Jun 20, 2017 by ibrahimn

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::InvoiceDate

Invoices::InvoiceAmount

invoices::S_SUM_Amount

Invoices:: Business Field

 

on Planned table

 

planned::date

planned::Amount

planned::S_SUM_Amount

planned::Business Field

 

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!

 

Ibrahim

Outcomes