Hello,
I am working on a graph that charts a cumulative amount (value) based on Maturity Date (the record).
However there are cases where there is more than one amount per maturity date (ie. Jan 1 has 6 different amounts). When my chart populates, it is ordering the amounts within each maturity date from lowest to highest before it performs the summary function.
How do I get it to populate the data as it is listed (within each maturity date) instead of ordering it from lowest to highest?
Your help is much appreciated, I need to get this done today!