Good day!
Can you please help me with a question in using a pivot table?
Using sample data, I want to add Calculated Item in a pivot table.
The structure of the PivotTable:
Filter: Category
Row: Product
Columns: Region
Values: Sum of Quantity
It shows 3 rows of Products when I chose Cookies for the Category.
Then I added a Calculated Item giving Formula West/East to show the Difference. However the pivot table added extra rows for Products which don't belong to these 2 Regions.
How can I only keep/show the 3 rows of these 2 regions (not the rows with Calculated Items #DIV/0!?
Thank you.
C3806.png
Bookmarks