Forum Discussion
NessFlood
Helper I
1 year agoCUMULATIVE SUM FOR MULTIPLE LINES
I am wanting a cumulative total for Actual, Budget and Forecast on the same line graph - the cumulative measure I'm using below works when I seelct my slicer but I think I need three separate measure...
- 1 year ago
thank you so much, that's perfect! 😃
NessFlood
Helper I
1 year agoHi there, below is a similar graph to what I want to achieve and the data is below, thank you.
| Type | Date | Value |
| Actual | 1 July 2024 | $315,540.35 |
| Actual | 1 August 2024 | $457,343.22 |
| Actual | 1 September 2024 | $506,849.83 |
| Forecast | 1 July 2024 | $315,540.35 |
| Forecast | 1 August 2024 | $457,343.22 |
| Forecast | 1 September 2024 | $506,849.83 |
| Budget | 1 July 2024 | $453,725.8282 |
| Budget | 1 August 2024 | $453,725.8282 |
| Budget | 1 September 2024 | $453,725.8282 |