Nprinting filter previous 12 months

[qliklizzy]

hello there,

I have set up a dashboard in Excel using nprinting report, using 6 objects from my app.

I have filters with nprinting on service which works, but I now need to filter on the previous 12 months - so today is June I need to show June2017 to May 2018 (completed 12 months)

So....

Can I do this with some kind of expression using the field filter?

or create variable within the APP and bring that through

- but which ever way - (and I have tried both and failed miserably) how do I do it ?

thanks for your help

[kjertmann]

I would create a flag in the load script, selecting the previous 12 month.