If condition

[Sgiri]

Hello All, 

     I have a field name called Year_number and it has values like 2020,2019,2018 goes on till 1980

I created a variable called vYear and added value as 1 so in the chart when I enter 1 I should get 2020 then when I enter 2 then I should 2019 and 2020 and when I enter 3 then I should get 2018, 2019 and 2020. I wanted to change it dynamically

Thanks

[Kashyap_R]

Hi

Try this 

Dimension = Year

Measure = Sum({<[Year] = {"=vRank(max(Year]))<=$(Variable)"}>}[Value])

Hope this helps

Thanks

[Sgiri]

I wanted to show that on dimension I have no measure to show.

[Kashyap_R]

Hi 

In which chart you should show these?

Can u more elaborate

Thanks

[Kushal_Chawda]

"When I enter" where you are entering? What you are entering?