It isn't very clear what you are looking for. Specifically, which column is previous month and which is the last 12? And what do you mean compare - I assume calculating the difference?
If you could also attach a workbook, that would work well.
please find the the workbook attached.
I had to modify the data therefore it Looks a Little weird the table.
I Need be able to filter on on a map the difference from "satisfied in %" from last month to "satisfied in %" as average from previous 12 months or 6 months or 3 months.
"satisfied in %" is calculated by "(satisfied/ participated)".
I tried calculated along the table with moving average but nothing works.
Your help would be highly appreciated.
test1.twbx 53.0 KB