AnsweredAssumed Answered

Need help setting up chart

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


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:





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