Skip to Content
Nov 20 at 09:36 AM

Urgent-WEBI Report - TTM(trailing twelve months)

76 Views Last edit Nov 19 at 07:09 AM 2 rev

Hello all,

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 --