Calculate difference in pivot table

[Sullivan]

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

[TABLE="width: 500"]
<tbody>[TR]
[TD]Product[/TD]
[TD]Date1[/TD]
[TD]Date2[/TD]
[TD] (DIF????)[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]100[/TD]
[TD]120[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]80[/TD]
[TD]90[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Product[/TD]
[TD]Date1[/TD]
[TD]Date2[/TD]
[TD] (DIF????)[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]100[/TD]
[TD]120[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]80[/TD]
[TD]90[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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!