YTD Formula

[gautik92]

I have a line chart where ill be having month as dimension

I need to show 24 months from aug back to 24 months

Measure is YTD

any idea?

[gautik92]

I want to show it in line chart

[Anil_Babu_Samineni]

Use the same formula.

[gautik92]

its not working in straight table itslef

[Anil_Babu_Samineni]

please share QVW

[gautik92]

Please check

[Anil_Babu_Samineni]

I think you need this not the YTD? Please change title to How to achieve this? Because, you need to refine the data from and fiscal year. May be look the links?

Fiscal Year‌

Fiscal and Standard Calendar generation

[Anil_Babu_Samineni]

And, Can you confirm till how many months you need accumulate? I am expecting bucket like (From 5th month - Which month)

[gautik92]

If month is august then april to august if it is march then from last year april to march same like that

[Anil_Babu_Samineni]

Please read first document and implement same. You will deserve this