Dynamic Sorting with Cyclic Groups

[#1]

Hi all, cyclic groups is great when I was making a chart to breakdown sales by different dimensions.

BUT, what if I need to sort it with expression using match function for a specific demension?

Thanks so much!

example:  I need to sort the Price Range, so that it's from low price range to high price range. How to do it if this dimension is in cyclic group?

[maxgro · Accepted solution]

if I understand your question you can conditional sort depending on the field you show using GetCurrentFieldofthe cyclegroup

example

=

if(GetCurrentField("<<KPICycle")='Sales Rep', wildmatch([Sales Rep], 'A*', 'R*', '*'),

if(GetCurrentField("<<KPICycle")='Product Group', wildmatch([Product Group], 'S*', 'B*', 'R*', 'A*', '*'),

wildmatch([Item Desc], 'Bett*', 'BB*', '*')

))

[#3]

Thank you Massimo, this is what I am talking about