Forum Discussion
Solved
Creating Custom Subrows as Percentage Changes
Hi,
I need to add a subrow that calculates of percentage change for between specific 2 different time periods as below.
| Type | Sum of Revenue |
| Yesterday | 229,925.28 |
| SDLM | 196,666.63 |
| Variance1 | 1.17 |
| Last 7 days | 1,348,787.62 |
| 7 days SPLM | 1,325,468.28 |
| MTD | 4,296,514.29 |
| SPLM | 4,280,047.93 |
| Variance2 | 1.00 |
| YTD | 13,437,909.68 |
| All | 54,389,536.48 |
I created the date periods before and they are dynamic by slicers, so I'm happy with this format because there are lots of measures except for Revenue.
I have tried to create matrix as below but it shows subtotals, it might give a clue,
You can find the sample report here:
Thank you,
VK
Here is the general approach
note that you cannot mix data formats unless you convert everything to to text.
8 Replies
Here is the general approach
note that you cannot mix data formats unless you convert everything to to text.
