# How to subtract two pivot table columns that already represent a percent of column total

1. ## How to subtract two pivot table columns that already represent a percent of column total

I have a two part question:

I have a pivot table where I display gross sales by brand(columns) for customers(rows) as a percent of column total for different years. In this case, separate columns display percentages that sum to 100% per column. I want to show the growth over years so I'd ideally like to subtract the 2019 numbers from 2020( two separate columns). Normally, I'd use a calculated field to subtract 2020-2019 gross sales, but I want the new column to display the differences of percent of column total. When I do this as a calculated field, I can't keep the values as a percent of the column total. For example, if brand A had 25% of its sales with customer A in 2019, and 35% in 2020, I want my new column to display +10%. Is there a way to do this?

I also want this pivot table to be adjustable to represent each cell as a percent of column total or a percent of row total. I already use a bunch of slicers so is there a way to include a slicer or drop down menu to filter between % of row and percent of column?

Thanks  Register To Reply

2. ## Re: How to subtract two pivot table columns that already represent a percent of column tot

I tried adjusting the source data for the pivot to represent percent of total. However, I want percent of total for each brand individually, not total sales.  Register To Reply

3. ## Re: How to subtract two pivot table columns that already represent a percent of column tot

HOW TO ATTACH YOUR SAMPLE WORKBOOK:

Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.  Register To Reply

4. ## Re: How to subtract two pivot table columns that already represent a percent of column tot

I have attached an example workbook  Register To Reply

5. ## Re: How to subtract two pivot table columns that already represent a percent of column tot

I changed the format of sheet 2 (all sales in 1 column).

After that a pivot table.

See the attached file.  Register To Reply

6. ## Re: How to subtract two pivot table columns that already represent a percent of column tot

Thanks for the response. However, I would ideally like to take: 'sum of 2020 sales'/column total - 'Sum of 2019 Sales'/Column total and create a new column with this information.  Register To Reply

7. ## Re: How to subtract two pivot table columns that already represent a percent of column tot

You mean like this?  Register To Reply

8. ## Re: How to subtract two pivot table columns that already represent a percent of column tot

Not exactly. Ideally it would display as attached. Here I manually inputted the data.  Register To Reply

9. ## Re: How to subtract two pivot table columns that already represent a percent of column tot

With helpcolumns on the data sheet.

The results are not the same.  Register To Reply