hide column in pivot table

[felcar2013]

hi

i want to hide a column in a Pivot table with calculate dimensions. See please attached file. I want to hide say, column KPI-1 , NC. There is only one expresion in the table and 4 columns based on the conditions

thanks

[Mark_Little]

Hi,

As fair as I am aware you can't hide columns with in a pivot table, you thought about maybe calculate the values in script?

Mark

[buzzy996]

hi,

i think u have to modify ur expression accordingly..it's not possible by using same expression&cal dim to hide ur column KP1-1.

HTH

[felcar2013]

hi, thanks,

i am changing the dimensions, and trying a new solution

[petter]

It is possible to almost completely hide some dimensions. You can use a macro to make the columns zero-width. Without the macro you could make them a few pixels wide making them almost invisible.

[felcar2013]

thanks

i was just creating the KPIs in the script and then creating a column for each of them, disadvantage is that i have a Report table with 48 columns and i wanted to cover all cases with 3 columns (TY, +/- %, linear gauge)

thanks anyway

[maniram23]

Hi,

try this one it will help full for you.

if(ValueList('KPI1','KPI2')<>'KPI1' and ValueList('NC','C')='NC',

sum({$<comp={1}>} sales),

  if(ValueList('KPI1','KPI2')='KPI1' and ValueList('NC','C')='C',

sum({$<comp={0}>} sales),

  if(ValueList('KPI1','KPI2')='KPI2' and ValueList('NC','C')='NC',

sum({$<comp={1}>} sales),

  if(ValueList('KPI1','KPI2')='KPI2' and ValueList('NC','C')='C',

sum({$<comp={0}>} sales)))))