AnsweredAssumed Answered

Need help setting up chart

Question asked by juandent on Jun 30, 2018
Latest reply on Jul 2, 2018 by juandent

Hi,

I have been breaking my brains on how to set up a chart. My situation is as follows:

 

I have a table A with fields {Name, DollarAmount, StatementDate} and I need to display for the current record in A (i.e. for a certain A.Name) all the past DollarAmount (as Y axis) for each existing StatementDate (as X axis) in table A.

 

Sort of like so:

 

$56,000

                      $35,000         

                                             $21,000

June-2018      May-2018       April-2018

 

 

I have tried to link 2 table ocurrences of A by A.Name but I only get the values for the current date.

I tried this in a portal and I got it working (now in FM 17 Pro Adv).

 

Please help,

Juan Dent

Outcomes