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
Bookmarks