10 Replies Latest reply on Jun 20, 2017 4:36 AM by ibrahimn

    Charts  Issue

    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