hide pivot column

[felcar2013]

Hi

is there a way to hide a column in a Pivot table containing two dimensions (vertical and horizontal). With value list, it was not possible to hide the column. For example, for "member" i want to Display only, "Active 12 TY" and "New Members" but not "Reachability" or in General the ones with "0".

dimensions are "month" and "Status"

thanks

Felipe

[Anonymous]

calculated Dimension does not work?

if (match(member,'Active 12 TY',,'New Members')>0, member)

[felcar2013]

hi, thanks, no, the Dimension is "Status". Member is value

[jonas_rezende]

Hi, Felipe Carrera.

Try the following steps:

1. Click with right-button on object chart pivot table;

2. In aba Presentation mark Suppress Zero-Values;

3. Click Ok.

Hope this helps!

[Anonymous]

I suppose that's not possible to suppress special columns like 'Active 12 TY' for Special dimensions like members but for others to Show them

you can only disable/enable columns completely (Show them for all values of your Dimension or none)

[felcar2013]

hi, i loaded a test file

under month, i have several months

[felcar2013]

i added data and an app, it seem it is not possible to hide columns, any other ideas?

thanks

[felcar2013]

hi Jonas, thanks, this is good for a Dimension value, where there is not Expression value (or "0").

Finally i used several straight tables, and tried to get the form i Need, this works, as it is possible to hide the Dimension, without loosing the values in it