repeating a value by fiscal year

[ali_hijazi]

Hello
I have in my dashboard two dimensnions (fiscal year and month)
I have a calculation to make which is the total attrition budget which is on the latest available month of the fiscal year
My fiscal year starts on October
I managed to get the number per fiscal as shown below; but I need to repeat this value on all months of the fiscal year:
so I want to repeat the -198 from 2023-10 till 2024-09 and repeat the -20 from 2024-10 till today 202412

[eddyvargas]

You need to create new fields

Example:

-create Fiscal Year and use Total <Fiscal Year>

-create "Fiscal Year Month" Field that is group of year months

[ali_hijazi]

Are you aware of the fact that using total<fiscal year> will ignore fiscal year if it is not a dimension in the chart?