Hide column in pivot table based on calculation of the column itself
I built a pivot table showing yearly sales for different dimensions + objectives of sales.
The table in QS looks like this
(by clicking on the + button you can drill down to the 5 other dimensions)
Users of my report don't want to see the objectives of sales for past years in this table (but we still need them in the report for other purposes) so I was able to hide the calculation for 2019, 2018 etc.. BUT now they ask me to remove columns "objective 1" and "objective 2" for 2019 and before - they just need these columns for the current year..
I've tried some options in QS dealing with hiding column if and using aggregates to calculate the sum of sales over a year and pass it as a condition to show or hide the column but no success.