Subtracting the difference between 2 values in a pivot while still showing the original values

[Tan9321]

HI, Can any one help me on this

The months shown below are values , with the heading on the column being MONTH, How can I subtract the two months while still showing the values of the months
I cant put in a calculated field as Month is the only heading, also if I use the Show total as difference between the 2 columns it will clear July 15 while only putting the difference of the two columns in the July 16 column and nothing in Sub Total

I have asked a couple of people who are advanced in excel but we are all at a loss on this, and yet it seems like it should be quite obvious
Data in which the table is shown is only dummy data as an example , actual file I would use would have a lot more columns which If I was doing something like this I would throw it all into a pivot to show July 16 and July 15 as headers and then pivot that data as my new table

Thanks a mill

T

[TABLE="width: 710"]
<colgroup><col><col span="3"><col span="3"><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sum of VALUE[/TD]
[TD="colspan: 2"]Column Labels[/TD]
[TD][/TD]
[TD][/TD]
[TD]Sum of VALUE[/TD]
[TD="colspan: 2"]Column Labels[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Row Labels[/TD]
[TD="align: right"]Jul-15[/TD]
[TD="align: right"]Jul-16[/TD]
[TD]Grand Total[/TD]
[TD][/TD]
[TD]Row Labels[/TD]
[TD="align: right"]Jul-15[/TD]
[TD="align: right"]Jul-16[/TD]
[TD="align: right"]Difference[/TD]
[/TR]
[TR]
[TD]HOME[/TD]
[TD="align: right"]4500[/TD]
[TD="align: right"]9100[/TD]
[TD="align: right"]13600[/TD]
[TD][/TD]
[TD]HOME[/TD]
[TD="align: right"]4500[/TD]
[TD="align: right"]9100[/TD]
[TD="align: right"]4600[/TD]
[/TR]
[TR]
[TD]LADIES[/TD]
[TD="align: right"]2900[/TD]
[TD="align: right"]7500[/TD]
[TD="align: right"]10400[/TD]
[TD][/TD]
[TD]LADIES[/TD]
[TD="align: right"]2900[/TD]
[TD="align: right"]7500[/TD]
[TD="align: right"]4600[/TD]
[/TR]
[TR]
[TD]MENS[/TD]
[TD="align: right"]1225[/TD]
[TD="align: right"]5250[/TD]
[TD="align: right"]6475[/TD]
[TD][/TD]
[TD]MENS[/TD]
[TD="align: right"]1225[/TD]
[TD="align: right"]5250[/TD]
[TD="align: right"]4025[/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD="align: right"]8625[/TD]
[TD="align: right"]21850[/TD]
[TD="align: right"]30475[/TD]
[TD][/TD]
[TD]Grand Total[/TD]
[TD="align: right"]8625[/TD]
[TD="align: right"]21850[/TD]
[TD="align: right"]13225[/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 192"]
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]GROUP[/TD]
[TD="width: 64"]MONTH[/TD]
[TD="width: 64"]VALUE[/TD]
[/TR]
[TR]
[TD]MENS[/TD]
[TD="class: xl65, align: right"]Jul-15[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD]MENS[/TD]
[TD="class: xl65, align: right"]Jul-15[/TD]
[TD="align: right"]125[/TD]
[/TR]
[TR]
[TD]MENS[/TD]
[TD="class: xl65, align: right"]Jul-15[/TD]
[TD="align: right"]150[/TD]
[/TR]
[TR]
[TD]MENS[/TD]
[TD="class: xl65, align: right"]Jul-15[/TD]
[TD="align: right"]175[/TD]
[/TR]
[TR]
[TD]MENS[/TD]
[TD="class: xl65, align: right"]Jul-15[/TD]
[TD="align: right"]200[/TD]
[/TR]
[TR]
[TD]MENS[/TD]
[TD="class: xl65, align: right"]Jul-15[/TD]
[TD="align: right"]225[/TD]
[/TR]
[TR]
[TD]MENS[/TD]
[TD="class: xl65, align: right"]Jul-15[/TD]
[TD="align: right"]250[/TD]
[/TR]
[TR]
[TD]LADIES[/TD]
[TD="class: xl65, align: right"]Jul-15[/TD]
[TD="align: right"]275[/TD]
[/TR]
[TR]
[TD]LADIES[/TD]
[TD="class: xl65, align: right"]Jul-15[/TD]
[TD="align: right"]300[/TD]
[/TR]
[TR]
[TD]LADIES[/TD]
[TD="class: xl65, align: right"]Jul-15[/TD]
[TD="align: right"]325[/TD]
[/TR]
[TR]
[TD]LADIES[/TD]
[TD="class: xl65, align: right"]Jul-15[/TD]
[TD="align: right"]350[/TD]
[/TR]
[TR]
[TD]LADIES[/TD]
[TD="class: xl65, align: right"]Jul-15[/TD]
[TD="align: right"]375[/TD]
[/TR]
[TR]
[TD]LADIES[/TD]
[TD="class: xl65, align: right"]Jul-15[/TD]
[TD="align: right"]400[/TD]
[/TR]
[TR]
[TD]LADIES[/TD]
[TD="class: xl65, align: right"]Jul-15[/TD]
[TD="align: right"]425[/TD]
[/TR]
[TR]
[TD]LADIES[/TD]
[TD="class: xl65, align: right"]Jul-15[/TD]
[TD="align: right"]450[/TD]
[/TR]
[TR]
[TD]HOME[/TD]
[TD="class: xl65, align: right"]Jul-15[/TD]
[TD="align: right"]475[/TD]
[/TR]
[TR]
[TD]HOME[/TD]
[TD="class: xl65, align: right"]Jul-15[/TD]
[TD="align: right"]500[/TD]
[/TR]
[TR]
[TD]HOME[/TD]
[TD="class: xl65, align: right"]Jul-15[/TD]
[TD="align: right"]525[/TD]
[/TR]
[TR]
[TD]HOME[/TD]
[TD="class: xl65, align: right"]Jul-15[/TD]
[TD="align: right"]550[/TD]
[/TR]
[TR]
[TD]HOME[/TD]
[TD="class: xl65, align: right"]Jul-15[/TD]
[TD="align: right"]575[/TD]
[/TR]
[TR]
[TD]HOME[/TD]
[TD="class: xl65, align: right"]Jul-15[/TD]
[TD="align: right"]600[/TD]
[/TR]
[TR]
[TD]HOME[/TD]
[TD="class: xl65, align: right"]Jul-15[/TD]
[TD="align: right"]625[/TD]
[/TR]
[TR]
[TD]HOME[/TD]
[TD="class: xl65, align: right"]Jul-15[/TD]
[TD="align: right"]650[/TD]
[/TR]
[TR]
[TD]MENS[/TD]
[TD="class: xl65, align: right"]Jul-16[/TD]
[TD="align: right"]675[/TD]
[/TR]
[TR]
[TD]MENS[/TD]
[TD="class: xl65, align: right"]Jul-16[/TD]
[TD="align: right"]700[/TD]
[/TR]
[TR]
[TD]MENS[/TD]
[TD="class: xl65, align: right"]Jul-16[/TD]
[TD="align: right"]725[/TD]
[/TR]
[TR]
[TD]MENS[/TD]
[TD="class: xl65, align: right"]Jul-16[/TD]
[TD="align: right"]750[/TD]
[/TR]
[TR]
[TD]MENS[/TD]
[TD="class: xl65, align: right"]Jul-16[/TD]
[TD="align: right"]775[/TD]
[/TR]
[TR]
[TD]MENS[/TD]
[TD="class: xl65, align: right"]Jul-16[/TD]
[TD="align: right"]800[/TD]
[/TR]
[TR]
[TD]MENS[/TD]
[TD="class: xl65, align: right"]Jul-16[/TD]
[TD="align: right"]825[/TD]
[/TR]
[TR]
[TD]LADIES[/TD]
[TD="class: xl65, align: right"]Jul-16[/TD]
[TD="align: right"]850[/TD]
[/TR]
[TR]
[TD]LADIES[/TD]
[TD="class: xl65, align: right"]Jul-16[/TD]
[TD="align: right"]875[/TD]
[/TR]
[TR]
[TD]LADIES[/TD]
[TD="class: xl65, align: right"]Jul-16[/TD]
[TD="align: right"]900[/TD]
[/TR]
[TR]
[TD]LADIES[/TD]
[TD="class: xl65, align: right"]Jul-16[/TD]
[TD="align: right"]925[/TD]
[/TR]
[TR]
[TD]LADIES[/TD]
[TD="class: xl65, align: right"]Jul-16[/TD]
[TD="align: right"]950[/TD]
[/TR]
[TR]
[TD]LADIES[/TD]
[TD="class: xl65, align: right"]Jul-16[/TD]
[TD="align: right"]975[/TD]
[/TR]
[TR]
[TD]LADIES[/TD]
[TD="class: xl65, align: right"]Jul-16[/TD]
[TD="align: right"]1000[/TD]
[/TR]
[TR]
[TD]LADIES[/TD]
[TD="class: xl65, align: right"]Jul-16[/TD]
[TD="align: right"]1025[/TD]
[/TR]
[TR]
[TD]HOME[/TD]
[TD="class: xl65, align: right"]Jul-16[/TD]
[TD="align: right"]1050[/TD]
[/TR]
[TR]
[TD]HOME[/TD]
[TD="class: xl65, align: right"]Jul-16[/TD]
[TD="align: right"]1075[/TD]
[/TR]
[TR]
[TD]HOME[/TD]
[TD="class: xl65, align: right"]Jul-16[/TD]
[TD="align: right"]1100[/TD]
[/TR]
[TR]
[TD]HOME[/TD]
[TD="class: xl65, align: right"]Jul-16[/TD]
[TD="align: right"]1125[/TD]
[/TR]
[TR]
[TD]HOME[/TD]
[TD="class: xl65, align: right"]Jul-16[/TD]
[TD="align: right"]1150[/TD]
[/TR]
[TR]
[TD]HOME[/TD]
[TD="class: xl65, align: right"]Jul-16[/TD]
[TD="align: right"]1175[/TD]
[/TR]
[TR]
[TD]HOME[/TD]
[TD="class: xl65, align: right"]Jul-16[/TD]
[TD="align: right"]1200[/TD]
[/TR]
[TR]
[TD]HOME[/TD]
[TD="class: xl65, align: right"]Jul-16[/TD]
[TD="align: right"]1225[/TD]
[/TR]
</tbody>[/TABLE]

 

[oldbrewer]

[TABLE="width: 1088"]
<colgroup><col width="64" span="17" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]GROUP[/TD]
[TD="width: 64"]MONTH[/TD]
[TD="width: 64"]VALUE[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD]MENS[/TD]
[TD="class: xl24, align: right"]Jul-15[/TD]
[TD="align: right"]100[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MENS[/TD]
[TD="class: xl24, align: right"]Jul-15[/TD]
[TD="align: right"]125[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MENS[/TD]
[TD="class: xl24, align: right"]Jul-15[/TD]
[TD="align: right"]150[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MENS[/TD]
[TD="class: xl24, align: right"]Jul-15[/TD]
[TD="align: right"]175[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MENS[/TD]
[TD="class: xl24, align: right"]Jul-15[/TD]
[TD="align: right"]200[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MENS[/TD]
[TD="class: xl24, align: right"]Jul-15[/TD]
[TD="align: right"]225[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MENS[/TD]
[TD="class: xl24, align: right"]Jul-15[/TD]
[TD="align: right"]250[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl24, align: right"]Jul-15[/TD]
[TD="class: xl24, align: right"]Jul-16[/TD]
[TD]TOTAL[/TD]
[TD="colspan: 2"]INCREASE[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]LADIES[/TD]
[TD="class: xl24, align: right"]Jul-15[/TD]
[TD="align: right"]275[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]MENS[/TD]
[TD="align: right"]1225[/TD]
[TD="align: right"]5250[/TD]
[TD="align: right"]6475[/TD]
[TD="align: right"]4025[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]LADIES[/TD]
[TD="class: xl24, align: right"]Jul-15[/TD]
[TD="align: right"]300[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]LADIES[/TD]
[TD="align: right"]2900[/TD]
[TD="align: right"]7500[/TD]
[TD="align: right"]10400[/TD]
[TD="align: right"]4600[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]LADIES[/TD]
[TD="class: xl24, align: right"]Jul-15[/TD]
[TD="align: right"]325[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]HOME[/TD]
[TD="align: right"]4500[/TD]
[TD="align: right"]9100[/TD]
[TD="align: right"]13600[/TD]
[TD="align: right"]4600[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]LADIES[/TD]
[TD="class: xl24, align: right"]Jul-15[/TD]
[TD="align: right"]350[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]LADIES[/TD]
[TD="class: xl24, align: right"]Jul-15[/TD]
[TD="align: right"]375[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]LADIES[/TD]
[TD="class: xl24, align: right"]Jul-15[/TD]
[TD="align: right"]400[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]LADIES[/TD]
[TD="class: xl24, align: right"]Jul-15[/TD]
[TD="align: right"]425[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]LADIES[/TD]
[TD="class: xl24, align: right"]Jul-15[/TD]
[TD="align: right"]450[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HOME[/TD]
[TD="class: xl24, align: right"]Jul-15[/TD]
[TD="align: right"]475[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 8"]a very simple sumproduct table that automatically updates as you add data in cols A:C[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HOME[/TD]
[TD="class: xl24, align: right"]Jul-15[/TD]
[TD="align: right"]500[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]seems to do what you want[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HOME[/TD]
[TD="class: xl24, align: right"]Jul-15[/TD]
[TD="align: right"]525[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HOME[/TD]
[TD="class: xl24, align: right"]Jul-15[/TD]
[TD="align: right"]550[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HOME[/TD]
[TD="class: xl24, align: right"]Jul-15[/TD]
[TD="align: right"]575[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]cell giving 1225[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HOME[/TD]
[TD="class: xl24, align: right"]Jul-15[/TD]
[TD="align: right"]600[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 7"]=SUMPRODUCT(($A$2:$A$47=$H9)*($B$2:$B$47=I$8)*($C$2:$C$47))[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HOME[/TD]
[TD="class: xl24, align: right"]Jul-15[/TD]
[TD="align: right"]625[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HOME[/TD]
[TD="class: xl24, align: right"]Jul-15[/TD]
[TD="align: right"]650[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MENS[/TD]
[TD="class: xl24, align: right"]Jul-16[/TD]
[TD="align: right"]675[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MENS[/TD]
[TD="class: xl24, align: right"]Jul-16[/TD]
[TD="align: right"]700[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Tan9321]

HI, Its for a pivot though that will be using new data all the time, I would have to do this on the side outside the pivot wouldnt I?

 

[SpillerBD]

You want to change the calculation for a Value Field Settings.
Still need a "calculated field, though it will just be to duplicate your Value field.
Then use "Value Field Settings" under the "Show Value As" to "Difference From" and set Base field to Month and Base item to "(previous)"

 

[oldbrewer]

add new data to mine and the table will update automatically, but it is not a pivot table