if i click on 2014 ,it should display 2015,2016 data also

[Anonymous]

hi Gurus,

if i click on 2014 ,it should display 2015,2016 data also

How to do this,

Thanks in advance

Please find the sample app

[GabrielAraya]

Hi,

Did you test with Set Analisys?

sum({<NewYear=>}[Final Spend])

Only({<NewYear=>}[Capital vs. Expense])

Only({<NewYear=>}[Contract Term Details])

Regards,

[Gysbert_Wassenaar]

See attached example.

[Anonymous]

Hi Thanks for your Time,

here the selection dependency on Contract Term,if contract term is 5 Year it should display 2014,2015,2016,2017,2018

Dynamic Display based on selected Contract term

[buzzy996]

just replace in  gwassenaar expression's wherever 2 is there with this  left(contractterm,1)

hopes tht helps.