Share via

Sum Specific Values within Pivot Table

Anonymous
2022-04-19T18:51:28+00:00

Hi there!

I've been working with a pivot table that has a number of unique columns, with 4 different values per column. My goal is to have a grand total with sums for only specific unique columns added together. The only workaround I've found so far is doing the sums outside of the pivot table, but this is inelegant and I'm hoping to make this work within the pivot table itself. Can that be done?

Sample:

Region 1 Region 2 Region 3 Grand Total
East West East West East West *Sum only East for Region 1 and 2 excluding 3?
Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-04-19T23:51:49+00:00

    Excel 365 Pro Plus with Power Pivot and Power Query.

    As Ashish suggested, PowerPivot with Slicers is a good option.

    With my very own database.

    https://www.mediafire.com/file/lz95h55996g2uiv/04_19_22.xlsx/file

    https://www.mediafire.com/file/95o6tg396x1vqgy/04_19_22.pdf/file

    Was this answer helpful?

    0 comments
  2. Ashish Mathur 102K Reputation points Volunteer Moderator
    2022-04-19T23:08:25+00:00

    Hi,

    This should be possible with a PowerPivot. Share the link from where i can download your Excel workbook and show the expected result there.

    Was this answer helpful?

    0 comments