How to Include Subtotal Percent in Pivot Table?

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?


Answers

  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon 🟀

    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')

Sign In or Register to comment.