Show Current and previous months data on table

tomf122 — Tue, 28 Jun 2022 13:10:46 GMT

I am trying to create a table in Qlicksense that shows the current months totals along with the previous months value all while having a filter on for a month. So say for example June -21 is highlighted then in the previous column it would show May-21.

Is this possible in Qlicksense and if so what would be the best approach to do so. I have had a look around and tried to create the data in SQL but having no luck getting to to be how it should be. I would just like to bring the column into the table if possible.

topic Show Current and previous months data on table in App Development

Show Current and previous months data on table