Is there a way to only show certain totals in a Pivot Table total column?

I created a Pivot Table and added a total column. I only need some of the row totals to populate in this column. Is there a way to exclude some of the totals from reporting?



  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon 🥷

    Unfortunately, there isn't. The closest thing is at the subtotal level and the option to suppress single item subtotals. Another option is to create a beast mode for your value field and replace values with null on items you don't want totaled and use that field as your value instead.

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