Hi, sorry I only have a picture, but hopefully it's a simple fix. I'm comparing product prices in a table with multiple sources using power pivot. I only want to see a product if it has a value (price) in both columns, if it only has one price I don't want it to be displayed. I can do this outside of pivot tables, however, if it's possible I'd like not to have to.
Columns - data source = HOUSE LIST
Rows - data source = PROD_CAT
Values - data source = LIQUOR_PRICE_DATA
Columns - data source = HOUSE LIST
Rows - data source = PROD_CAT
Values - data source = LIQUOR_PRICE_DATA