-
1. Re: Subtotals Using Specific Dimension
lei.chen.0
Apr 2, 2017 11:37 PM
Hello Abhishek,
Please try this setting.
Regards
Lei
-
2. Re: Subtotals Using Specific Dimension
Hello Chen,
Thanks for replying to the post but as you can see when we are selecting hide option, it is hiding all the subtotals but I want it display for category.
Regards,
Abhishek
-
3. Re: Subtotals Using Specific Dimension
lei.chen.0
Apr 4, 2017 1:25 AM
Hello Abhishek,
Just hide from the [Rank] menu.
From the screen shot, you can see, the subtotals for Category and State are still there.
Regards
Lei
-
4. Re: Subtotals Using Specific Dimension
Hello Lei,
Sorry, I think I was not clear in my previous response but as you can see though total is there but there is no value against it. Could you please walk through to get the value against total.
Regards,
Abhishek
-
5. Re: Subtotals Using Specific Dimension
lei.chen.0
Apr 4, 2017 3:01 AM
Hello Abhishek,
Sorry for my carelessness!!!
Please try removing the hierarchy for Category and Sub-Category.
Workbook attached for your reference.
Regards
Lei
-
6. Re: Subtotals Using Specific Dimension
Hello Lei,
Thanks for the help, but when I am changing the rank calculation from table down level to sub category level then it is causing the same issue. Kindly help so that I can get the desired result. I have attached the workbook for your reference.
Regards,
Abhishek
-
7. Re: Subtotals Using Specific Dimension
lei.chen.0
Apr 4, 2017 6:20 PM
Hello Abhishek,
To sort desc by SUM(Sales) under [Sub-Category], I suggest do the table calculation as follows.
It seems that when only [Sub-Category] is checked, the computing result of [Rank] for Total row is 1, thus Total is combined to the first row of the [Sub-Category] which has the largest sales.
Regards.
Lei
