I have three measures in my table.
Measure 1 - Rolling balance from the current and previous month.
Measure 2 - PeriodRolling revenue for the last three months including current month
Measure 3 - Calculation using measure 1 and measure 2 and the number of days.
I have created all three measures in the RPD.
The table is by state. So it could be Texas, New York, Illinois and so on.
| Month | State | Measure 1 | Measure 2 | Measure 3 |
|---|
| 1 | Texas | 17565 | 9898989 | 45 |
| 1 | New York | 97848 | 8748575 | 43 |
| 2 | Texas | 85768 | 8734874 | 33 |
| 2 | New york | 94855 | 3234442 | 23 |
The chart shows the trend of Measure 3 by time for each state. I need a line on the chart to show the total by month. Do I have to create a sum() formula in the RPD? Appreciate any ideas that you can throw at me.