I need a create a webi report to show Last 12 months data according to current date -- in 12 coloums for each month(last 12 months) --
for example -- if current month is nov --- i need a Column with current month data and need last 12 months data in each month column like ---
Oct 2021 - nov 2021- dec2021-jan2022-feb2022 --so on till current month.
If current month is Dec 2022 -- i need Nov 2021-Dec 2021-jan 2022 so on till Dec 2022 ---
Edit1: I have created a current month variable - and i am getting current month data but need last 12 months columns --- please help
Please help me with this its urgent --