Oct 11 2018 10:19 AM
Hi,
I'm trying to do a basic "Show Value As" calculation in my pivot table - I want the column that I'm adding to show as a % of the Grand Total. However, after I select the "% of Grand Total" option from the drop down in the Value Field Settings window I am unable to select the base field - they are all grayed out:
My source data is within the same excel workbook. Any help would be greatly appreciated!
Oct 11 2018 10:42 AM