Apply filter in pivot tables

[sguerra2]

Hi Community,

I have a pivot table that has as columns Year month- I just need 2021 info to be visible.. I tried with a set analysis to the measure, the information seems to be filtered but not removing the colums that belong to 2020 data-- i am not able to filter JUST info and columns just for year months that belong to 2021 info..any suggestions?

Thanks a lot!

@fmonetti 

Sofía

[MayilVahanan]

Hi @sguerra2 

Try like this

Sum({<Year={2021}>}yourexpression)

For dynamic,

Sum({<Year={$(=Max(Year))}>}yourexpression)

And suppress the zero values.