Great video. I would suggest that instead of sorting on Sub-Category, create a combined field with Category and Sub-Category, and replace Sub-Category with it. Create the Sub-Category plus other exactly like you did. However, compute all table calculations using the combined field instead. The reason behind this is that in the video, you're sorting not by Sub-Category within Category, but instead by Sub-Category as a total. This would create problems if there is the same Sub-Category value within two or more Categories (which is the case for many of us watching this).
Thank you for the video. How can this be modified to ensure ties are handled and other category is always shown along with Top.
finally found this video to solve my proble problem！thank you
I’m glad this video helped you!
Hi , how do convert it to percentage of total
Great video. I would suggest that instead of sorting on Sub-Category, create a combined field with Category and Sub-Category, and replace Sub-Category with it. Create the Sub-Category plus other exactly like you did. However, compute all table calculations using the combined field instead. The reason behind this is that in the video, you're sorting not by Sub-Category within Category, but instead by Sub-Category as a total. This would create problems if there is the same Sub-Category value within two or more Categories (which is the case for many of us watching this).