Thank you for quick feedback!
Unfortunately it does not work as I would like it to.
Each of our Partners sells a set of Product Categories. They are not limited to single Product Category. Therefore I would like to see each Bar split by color.
In your example each Customer would have Blue, Orange, Green and Red on Bar Chart.
Similar to this example:
But of course with Ranking by Two Dimensions.
Below is the Trick:
1. Create a Table Calculation and Drag it to the details
Use the above created calculation (Total Sales) in the Rank
3. Convert the Rank to discreet and add it to the rows shelf as shown below.
Rank Table Calculation should be addressed as shown below:
Hope this helps!!
Please find the attached workbook as well!
Rank.twbx 1.2 MB
Good Job !! Venu
Are you able to find the solution to your problem?
It would be great if you mark this as correct answer!!
I don't think I can mark Correct Answer when I'm not a original requester.
Could you mark Venu's one correct answer if your issue is gone.
It was helpful, however it didn't fix my issue in 100%.
It should be noted that I have 2 dimensions in rows, instead of 1.
I want it to keep following order:
Country / Ranks 1-10 / Partner Name
With Sales colored by Product Categories.
How should I change your logic in order to keep Country as first dimension? For every Country I would like to show Top 10 Partners by Sales with color by Product Categories.
I have managed to fix my issue based on Venu idea.
Thank you for your help!