Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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*', '*')
))
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*', '*')
))
Thank you Massimo, this is what I am talking about