Text indicator to show % change from previous period
I want my text indicator to show the % change from the previous period.
Ie. If the sales in 2024 were $100 and the sales in 2025 were $110, I want the text indicator to show 10%
8 replies
-
Here are 3 techniques for YOY %.
- Technique 1 is not exactly what you wanted - but it's good to know.
- Technique 2 is easiest.
- Technique 3 is a little harder, yet more powerful.
PS: For technique #2, use "Percent Difference Of..." not "Percent Of".
-
I've added a 2024YTD column into my report. When I use the YOY% it functions perfectly on all the other columns, but not the 2024YTD. For 2024YTD is just shows the value found in the 2024YTD column and not the YOY% from 2023. Is there a way to do this?
For reference: https://community.pyramidanalytics.com/t/35yfsgw/add-a-column-that-shows-previous-year-ytd
-
It doesn't work because there is no "previous member" for 2024YTD in the semantic model. This is a custom member calculation. If you used the context calculations it would work, because it reads off the values from the report structure itself - that is, based on the context of where the calculation is run. (And BTW, what is the previous period for 2024 YTD ?)
The best approach, if using track 3, is to add If/Then logic to your formula, that says, "If the current member is '2024 YTD', do this formula, otherwise to that formula".