formatting a Pivot table

maggiewachira — Fri, 08 Nov 2019 17:02:11 GMT

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

topic formatting a Pivot table in App Development

formatting a Pivot table