Display Sum YTD actual and Future budget on pivot table
Hopefully this is doable but I'm drawing a blank on displaying actual and budget numbers on a pivot table.
So here's my scenario:
I have a pivot table with a dimension(account) and two measures(Amount(YTD) and Amount(FD)), the requirement is to show sum of actual for past accounting periods and sum of budget for future accounting periods.
Plotting accounts vs both measures gives a pivot table with $0.00 columns and data handling option doesn't seem to work, Is there a way to suppress the zero columns?