conditional show (sub)column in pivot table

[curiousfellow]

I have created a pivot table with column year and three subcolumns  sum(sales),count(articles), sum(credit_sales)

Now I want to display credit_sales only for the highest year.

Because I cannot find a way to hide the column credit_sales for previous years I did a conditional formatting where font color is white for previous years.

Only thing to solve now is how to conditional format the columnheader for credit_sales, could you help me with that ?

[Gysbert_Wassenaar]

Try something like =if(Year <> max(total Year), argb(0,0,0,0),0)

[sunny_talwar]

Do you have a sample you can share?

[Anonymous]

Did you check this?

Using Column Visibility | Qlikview Cookbook

Hiding columns in a pivot table | Qlik Community

[curiousfellow]

In those examples the subcolumn is shown or hidden for all years, also for the highest year

[curiousfellow]

This works for the values but not for column headers

[Gysbert_Wassenaar]

Works for me.