I have a pivot table that uses filters to group data. This means I can see totals easily the total is made up of 100 records each with a value and the value is then summed.
For example:
A = 45000
Where a is a client and value is sum of client records for a specific field.
What I want to add is a column that will take whatever the filter has been set to and compare to same period last year, indicating the %increase or the %decrease.
Cannot get my head around this one.
Any pointers?