Can we get the ranks/index based on dimension similar to serial number.
For Egs. for the list of below countries, I want rank without considering any expression or measures.
I need to give alternate colors based on row banding in a table chart. From the above Australia row in blue, India row in White, UK in blue, US in white and it goes on.
I have dynamic products for each country and sales for each products. I am able to achieve the rowbanding by giving background color to the expressions(hardcoded).
But when the number of products vary for each country the color doesnot get aligned.
If I can get the rank for each country, this will help. The countries are displayed in Alphabetical order. Hence sorting cannot be done based on expressions.