Calculate YTD and PYYTD based on current year period with takes year selections

[Gopi_E]

Hi,

               I have a column like Year and Date and I want to show YTD and PY YTD. I did this Scenario, the problem was it should be showing the sales based on current year period, That means the current year sales date range is 1/1/2018 to 06/26/2018, So if I select 2017 year filter it should be showing the sales between the above date range only. Please check given excel and give some clues

my expression for getting Sales is

For Current Year:  Sum({<Year={"=$(=Max(Date))"}>}Sales)

For Previous Year : Sum({<Year={"$(=Max(Year)-1)"},Date={"<=$(=Max(Date))"}>}Sales)

[sunny_talwar]

So, if you select 2017, you would want to see 1/1/2017 to 06/28/2017 for Current Year expression or Previous Year expression?

[Gopi_E]

Hi Sunny,

Sorry for late reply, Here I want to see both years based on current year YTD, For Example, if I click 2017 it will show 2017 and 2016 sales, and it should return sales between as you mentioned dates.

Thanks,

Gopi