Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All-
I have a pie chart that uses a cycle group for the dimension to show total payments by payment category, primary diagnosis and claim type. I am using dimension limits, restricting to show only the largest 11 (which includes Others category).
I would like the cycle group dimension label to read "Payment Category - Top 10" when
GETCURRENTFIELD(PaymentCatClmTypeDx)='PaymentCategory'
and the Top 10 payment categories are shown but to read "Payment Category - Others" when "Others" is selected.
For example:
But when "Others" is selected, I would like the dimension label to read "Payment Category - Others".
Is there any way to specify the selection of the Others category? Or is there a way to use RANK and AGGR since I am showing the top 10 and Others encompasses the rest of the groups?
Thanks!
bump
Interesting question, I have a different but similar situation. Wish I could help but I'll be keeping an eye out...