keep all columns in pivot table even after filter is applied in another sheet
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.