Can any one help me with a calculated item in a pivot table. I have a simple pivot table with:
Acct, Type, Amt for Today, Amt for Yesterday, Net Change
The Net Change is a calculated item based on difference from today and yesterday.
Results are giving me a report of all accts and types regardless if they have data. If I remove the net change, I get just the rows that have data not zeros or blansk, when I add the net change back in, I get a row for every acct and type combination regardless if there is data
Acct, Type, Amt for Today, Amt for Yesterday, Net Change
The Net Change is a calculated item based on difference from today and yesterday.
Results are giving me a report of all accts and types regardless if they have data. If I remove the net change, I get just the rows that have data not zeros or blansk, when I add the net change back in, I get a row for every acct and type combination regardless if there is data