Hi all,

Suppose I have a pivot table with sales region (rows) and product type and year (columns).

So for instance I should see for the South Region, Grocery Sales were $### for the year 2020. Easy.

The problem is that when I go into (double click the number) South Region, Grocery Sales in 2020 I see sales are being included that are not in the Grocery Category.

Why would this be?

Thanks