You'll need to change the settings on your Index() table calculation. I don't have as much experience as some, so I cannot give you specific instructions without seeing how your view is laid out (where dimension/measure pills are). Alternatively, if you can post a sample packaged workbook that demonstrates your problem, someone will post the solution for you. It is very difficult for us to answer this type of question without a visual representation of the data.
The good news: Tableau is perfectly capable of doing what you want! If your data is sensitive, you can dummy it down or re-create your situation using the sample data provided by Tableau.
I have recreated it with the sample workbook. As you can see the sorting on the product sub category as well as the rankings are not correct.
I have the index function calculating based product sub category.
I believe this is what you want.
I did the following:
1) Swapped your layout (just my preference, but I think its easier to view this way).
2) Right click on rank>> Edit table calculation>>Compute Using>>Advanced
3) Addressing set to Day of Order Date, Product Sub-Category (in that order, top to bottom--this matters!)
4) At the level: deepest, Restarting Every: Day of Order Date
Is this what you wanted? If it is, I have just resolved my first table calculation issue for a forum member
Awesome, Thank you. I've been messing around with this formula for a while now and couldn't get that one figured out. I was missing the event date part of the calculations.
Thanks a ton.
Believe me, I am as excited as you. Table Calculations can be extremely confusing at first. If you will need to use them often, I would familiarize yourself with some of the linkage provided by Jonathan Drummey here:
Yes I have been using them alot, but mainly the basics. I have used that website before for the grand total issues I was having.
Thanks again for all your help.