keep all columns in pivot table even after filter is applied in another sheet

[subrato312]

I have two sheets. In sheet2 I have a pivot table with columns as 'year' (2015 to 2018), so when I apply a filter '2018' in sheet1 and then when I move to sheet2  only 2018  column is visible. I want to keep all four columns in sheet2. 

year is calculated from field 'Order Date' as [Order Date.autoCalendar.Year]

Please help me in ignoring filter in pivot table in sheet2.

Thanks for your help

[harishicon · Accepted solution]

Hi,

you can bypass the Year in the measure. 

ex: sum({<[Order Date.autoCalendar.Year]>}[Order Total])

[jonathandienst]

Add a set expression selection override into your expression. Something like

Sum({<[Order Date.autoCalendar.Year]>} Amount)

[subrato312]

This works well but in cases where there is no value for any year then only three columns are visible. Is there any way to keep all columns in case there is no value for a certain year?