I have an issue in that i'd like three different metrics to display growth rates month on month in a table. However i'd like these three metrics to be selectable from a parameter in order to display value growth, volume growth and active card growth.
i have created the seperate calculated growth fields with the following formula which works well when pulled into the table:
However when i create a parameter calling on my three calculated growth fields, no values display so the parameter doesn't work.
Is there a workaround that anyone knows of?
I just need a parameter that allows metric selections of growth rates month by month.
You should be able to use a parameter to switch between different calculations. Can you post a packaged workbook? Did you create a parameter, as well as a calculation that leverages the parameter?