Calculate difference in pivot table

[Sullivan]

My database is a set of dates, products and sales values. I created a pivot table like this:

Product	Date1	Date2	(DIF????)
A	100	120
B	80	90

<tbody>
</tbody>

I am trying to set a column to automatically calculate the difference between the two dates, without sucess. My first try was to generate a Calculated Field, but it does not recognize different dates.

Any clues?

Thanks!

 

[Sullivan]

Anyone that could give me a clue?

My database is a set of dates, products and sales values. I created a pivot table like this:

Product	Date1	Date2	(DIF????)
A	100	120
B	80	90

<tbody>
</tbody>

I am trying to set a column to automatically calculate the difference between the two dates, without sucess. My first try was to generate a Calculated Field, but it does not recognize different dates.

Any clues?

Thanks!