Pivot Table calc difference between two rows of data

R

Robert H

In a pivot table that has just two rows of data I would like to
calculate the difference between the two rows (row1 - row2) for all
the columns.

One thing I tried was to select a cell in the Grand Total row, right
click and select Value Field Settings then enter Custom Name "Diff".
Then in the Show Value As tab, select Difference From and "row1" and
ok.
the data in rwo1 is now blank, row2 is is not what I expect and the
grand total is blank.

So I apparently dont have a clue about this and need to be pointed in
the right direction.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2013 Merge Data 2
Deleting blank rows 4
How to include the Grand Total Column in a pivot table chart? 1
Average of Subtotals in Pivot Table 0
subtracting two pivot table data fields 1
Pivot using 250,000 rows of data in Excel? 1
Pivot Table Calculated Fields 1
concatenate formula for rows with differing amount of columns 3

Top