Change order of Grouping based on a prompt

[PreetiGanamani]

Hello all,
Please do help me out with this.

I have to change the order of grouping based on a prompt.

for example i have 4 columns A, B,C,D.

Scenario 1
No grouping

Scenario 2
Group by A,C and D

Scenario 3
Group by B,C and D

Scenario 4
Group by A,B,C and D

Scenario 5
Group by B,A,C and D

Please do help me out with this. Thanks in Advance
Preeti

 

[KingCrab]

Add a case statement to several data items and add this data item to the dimensions you want to sort.

CASE ?Prompt?
WHEN "ABC"
THEN "a"
WHEN "XYZ"
THEN "b"
ELSE
"c"
END

 

[PreetiGanamani]

Thanks for the prompt reply. i am working on it right now.
Thanks for your help.