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

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

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • @MarkSnodgrass is there a way to show the percent of the category instead of the total percentage of the subcategory in the subtotal?