Year Month wise YTD and YTD-1

[rupaliqlik]

Hi folks,

I have a table where I am showing YTD and YTD-1.I am taking Dimension Year_Month which contain data from 2019-10 to till date.

Previous Fiscal Year:- 2019-10 to 2010-9

CurrentFiscal Year:- 2020-10 to 2021-9

Dimention:- Year-Month 

My formula is like

CY Gross=Sum({<AY={'2021'}>}Gross)

PY Gross=Sum({<AY={'2020'}>}Gross)

And I want data should be look like below.

But In my dashboard chart showing Year month started from 2019-10 which I don't want to see.

YTD and YTD-1 should be come below each other.

Above result should not be come.

@Sunny_talwar, @Swuehl,@ kaushik.solanki ,@sunny t,  @https://community.qlik.com/t5/user/viewprofilepage/user-id/22678

[J_Lindberg]

Hello @rupaliqlik , 

It appears that this question has ended up in the wrong forum. In this forum we're able to help you with Qlik Application Automation related questions.
It would be great if you could post this question in the forum related to the product you are using.
I'm not sure if this would be something for the Qlik Sense forum (https://community.qlik.com/t5/Qlik-Sense/ct-p/qlik-sense) or the Qlik View forum (https://community.qlik.com/t5/qlikview/ct-p/qlikview).