Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to draw a line graph for the top x customers.
The code fro the line graph is currently
(
SUM({$<[Business Date]={$(='"<='&DATE(MAX([Business Date]))&'"')}>} [Cr Balance]))
The code for the Top X is
IF
Both of these work, but how do I put them together?
What I would also like to do is then draw a line for the minimum balance for the sum of the top x customers (i.e. a flat line)