Suppress Column in pivot table

[inescastelhano]

Hi all,

I have the following pivot table, and I would like not to show the column "Total" when it has no data. For example, april and may has no data, so I would like to hide these columns. I have "Suppress when value is null" and "Suppress zero values" checked.

Any help would be appreciated.

Thanks in advance.

Cheers,

Inês

[Gysbert_Wassenaar · Accepted solution]

As you can see the Total column has values in jan and feb. That's the reason it will be shown for all months. You can't suppress it. It will always be shown for all the month values as long as there's at least one value for one month.

[amit_saini]

Hi,

I think this is not possible in pivot table , but let's wait for experts suggestion.

Thanks,

AS

[arthur_dom]

You could do it by creating a big straight table. With 24 expressions ( 12 for total and 12 for total PY ), and on each expression create a conditional.  

[krishnacbe]

Hi

In pivot we can't hide columns. Try with Straight table.

[inescastelhano]

So then can I hide the months which are after the current month? for example, not to show may, june, july, etc.

[arthur_dom]

Yup, but that will depend on your conditional

[Gysbert_Wassenaar]

That should be possible. You could simple select the months you want to see or change the expressions in your pivot table to exclude the months you don't want to see.