If I have two sets of numbers classified as Actual and Budget, is there a way to show the difference between the two in a pivot table formula? Or in any other manner in a pivot table?
Currently I have the column headers in the pivot showing Actual and Budget, with their corresponding amounts below. But I don't see how I can have another column showing the diff between the two. Thank you.
Bookmarks