How to Include Subtotal Percent in Pivot Table?

MountainClimber303
MountainClimber303 ⚪️
in Card Building

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?

image.png


Tagged:

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

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Categories