Sorry, I want just change the Measure only in the Row Shelf Dynamically by using parameters, Not swap from Column to Row Shelf.
Just like Parameter
1 of 1 people found this helpful
Use the CTUS method for parameters:
Create a parameter as a list of values.
Tie - in:
Create a calculated field that references the newly made parameter.
Replace the sum(Profit) with the new created field.
Show parameter control:
Now you should be able to switch between the measure types for Profit.
Is this is possible to select different measures like Sales and Profit
Hi sudha Appireddy.
both of the answers given by pooja and joshua were correct. try it from your end . you will get the desired result.Marks the answers as correct if u find the reply were correct
Joshuas answer shows all you need to accomplish what you want.
To select different measures just modify the calculation to something like this:
CASE [Measure Switch]
WHEN "Sales" THEN SUM([Sales])
WHEN "Profit THEN SUM([Profit])
Note: you also have to change the naming of the parameter values to match the switch cases.