Forum Discussion
Help! "Show Value As" calculations in Pivot Table Grayed Out
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" o...
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.