When in the analyzer, I selected a pivot table
Next, Chart Properties --> Subtotals --> check the box for "Show Subtotal Rows"
This gives me the subtotal for each subcategory.
Is there a way I can also show the percent total for each subcategory?
You need to get a feature enabled that is not enabled by default. Ask your CSM to enable "Window Functions for Beast Modes". Once that is enabled you can calculate this number by creating a beast mode like this:
COUNT('Supplier') / SUM(COUNT('Supplier')) OVER(PARTITION BY 'Subcategory')
@MarkSnodgrass is there a way to show the percent of the category instead of the total percentage of the subcategory in the subtotal?
