Help! "Show Value As" calculations in Pivot Table Grayed Out

Rachel Greenberg
Occasional Visitor



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:

show value as issue.PNG

My source data is within the same excel workbook.  Any help would be greatly appreciated!

1 Reply
I have 2 sheets A & B. Sheet A has 3 columns: Store name, Location and no. of products, (50 rows) Sheet B has 3 Columns, Store Name, Location and No. of products (2400 rows), i have values for store name and location in this sheet. Now i want to have value of no. of products in Sheet 2 on condition that combination of store name and location should match in sheet 1 to give me corresponding value. Which formula should i use.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies