Hey,
I have created the following pivot table as shown below.
However, when I view the pivot table it appears the column totals aren't totally for a certain value of the 'Forecast' field.
I'm super confused on why they could be calculated correctly when the 'Forecast' column is equal to 'Forecast', but not equal to 'Current'