Thanks for your time,
Others always should display in last of each segment and need to show all sub totals.
Can you please change the twbx file version from 10.2 to 9.3.. Because I am using 9.3
Thanks a lot,
I have only 10.xx versions installed on my machines, so you better refer Gourav's post.
As Gourav said, the best option that I also see it making 2 different sheets.
The way I have achieved this is by creating 2 sheets and using the index function.
Rank: Table calculation -
Compute using: Advanced> Select Segment then Sub-category> Sort by Sales, Sum , Decending
At Level: Subcategory
Restart every : None
Same Rank Table Calculation
So if you see ... Both of them align and are in proper descending order. The biggest problem is the sync scrolling.
Hope this helps, or you can work to a better solution through this.