formatting a Pivot table

[maggiewachira]

Hi guys,

I have a quick  question. I have a pivot table that shows data when two dates are selected. If we select those dates the data is represented as shown the table below. 

I want to add a third column that compares the two infront of it like so

If this is not possible, I would like to go with a different pivot table just for the comparision but still referencing the first table.

The way it works, region values are sumed up based on the date selections. in order for this to work, users must pick 2 dates. the comparison column compares the data beween these two dates. so GL of date 1 to GL of date 2 and so forth.

(As of 1st date - As of 2nd date) / As of 1st date

Thanks,

Maggie