Hello!
I created a rank order with a filter toggle box to choose between dollars and units. For some reason when I pick units, the ranking order is off by one brand, but when I choose dollars, all seems fine in rank order of brands. I've tried manipulating the sort order but really not the issue from what I see. I've attached an example workbook version 10.1, which you will see that when units is chosen the Nescafe brand falls after the Eight o Clock brand, which is out of rank order, but when dollars picked, it's fine.
I'm hoping that someone can help me on this as it seems to be something I'm missing. Also added to context the brands and other dimensions, but that didn't do the trick either.
Thanks in advance for your help.
-Milton
Hi Milton,
I Just tried to resolve your issue and i can see it working as expected by you.
The only thing that you are missing here is because while you are trying to edit your computation it is based on Total while your calculation uses Total format measure just replace your measure calculation Total with Total format and it will work as expected.
Regards,
Saumya Shetty
