Differences in Pivot field amounts

Topic

New Reply

I have to compare export files with original data prior to loading into a new software system. So I have a sheet where I stack the export file data on top of the system data. In Column A for the export data has “Export” in each row, and for System Data it has “System”. I then create a pivot table with Cost as the data, account as the row field and Column A as the column fields. They nicely line up so I can see if the totals per account agree System vs. Export. So far so good. I would like to make the table show any differences. My only idea centered aound a calculated field, but since System and Export are in the same column A, that won’t work. So I wind up having to do formulas to the side, which then disappear or shuffle around as I change the way I’m looking at data. So my question is: Is there any other way to get that calcualtion inside the table. It would save me much work. Thanks in advance.

Reply | Quote

Replies

You need a calculated item, not a calculated field. Define one as System-Export in the columnA field.

Reply | Quote

I don’t understand the situation See the upload attached. I thougth I was doing as suggested, but must be missing something important. I’m looking for the table to include a filed such as COL F shows, so I’m not constantly doing Column F each time teh table changes. Thanks again.

Reply | Quote

I just had a try at adding a calculated item – I found that you have to select cell B4 on the pivot table to do what you want. By selecting this first and then using the Pivot Table options to add a calculated item, this will give you a calculated item after the Old column and before the Grand Total Column showing the difference between New and Old.

Regards,
Maria

Reply | Quote

Worked fine. Thanks!

Reply | Quote

Worked fine. Thanks!

Reply | Quote