How do I get future data being populated to current year?

yogesh_1

I have a requirement to show Next fiscal Year data into Current chosen fiscal year. So if user choses , FY 23, it should show data for Fy24 in 1 column.

Please see below: If FY is selected, then monthly data is shown for current fiscal year.

and similarly NextFy data (Fy+1) is also displayed like below. Please suggest.

	Oct-22	Nov-22	Dec-22
FY	100	200	445
NextFY	150	234	221

michiko

1. Supposed your data is stored as below

2) create a beast mode called Offset Date

case
when FY = 'FY' then Date
when FY = 'FY+1' then DATE_SUB(Date, INTERVAL 1 year)
end

3) Construct a crosstab like below.

4) You will need to tweak the beast mode a little bit more if you want to be able to select other FY values

michiko

1. Supposed your data is stored as below

2) create a beast mode called Offset Date

case
when FY = 'FY' then Date
when FY = 'FY+1' then DATE_SUB(Date, INTERVAL 1 year)
end

3) Construct a crosstab like below.

4) You will need to tweak the beast mode a little bit more if you want to be able to select other FY values

yogesh_1

@michiko Yes, the flexibility is given to users to choose the required fiscal year.

Also can you explain this:

case
when FY = 'FY' then Date
when FY = 'FY+1' then DATE_SUB(Date, INTERVAL 1 year)
end

michiko

The beast mode creates the respective offset date so that the date align back to FY