Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
you can bypass the Year in the measure.
ex: sum({<[Order Date.autoCalendar.Year]>}[Order Total])
Hi,
you can bypass the Year in the measure.
ex: sum({<[Order Date.autoCalendar.Year]>}[Order Total])
Add a set expression selection override into your expression. Something like
Sum({<[Order Date.autoCalendar.Year]>} Amount)
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?