Cyclic group with different sum of sales amounts

[#1]

Hi I want to create a cyclic group allowing users toggle between 3 various different sum of sales amounts :

SALES_1

SALES_2

SALES_3

I created a new cyclic group and added 3 calculated dimensions using SUM(SALES_1) ... however I get an 'Error in calculated dimension' error'. Is there a better way to go around this ?

[Kushal_Chawda]

Please see the attached. I am able to create the cyclic group

[#3]

Thanks Kush. The sales figures all need to be in one column  under a single cyclic group so you can toggle between them.

[Kushal_Chawda · Accepted solution]

Please see the attached.

Create a Group of Expression

[#5]

Thanks. I think someone else referenced this too. But it's the group feature that essentially makes it work. Hadn't used this before but looks very useful.