I have a pivot table that is feeding from a data connected excel table, in that table there is a column labeled status and it contains the number 1,2, or 3 it also contains 12 columns (January-December) under the month columns it contains various amounts. My pivot table under "Values" pulls in the month amounts just fine I have the values summed but when I add the Status to the values and say sum the values it turns them into "0" any ideas why it pulls the amount for the months in just fine but not the status column amounts
Bookmarks