Greetings,
I have created a Pivot Table calculated filed to display Error. For example, January's calculated field for Error is (January's Actual - January's Forecasted)...works fine
However, I need one more calculated field to show ABS 2 Mo. So, the ABS 2 MO would take the Absolute Value (Sum ( December's Error + January's Error)). Is there a way to show this calculation in a Pivot Table's calculated field?
Thanks!
DJ
Sometimes to solve pivot table issues you have to play with the source data and perhaps add helper columns to them. Without seeing what your source data looks like, I can't be more specific than that.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks