

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Suppress Column in pivot table
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
- Tags:
- pivot table columns
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
talk is cheap, supply exceeds demand

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
talk is cheap, supply exceeds demand


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
I think this is not possible in pivot table , but let's wait for experts suggestion.
Thanks,
AS


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
In pivot we can't hide columns. Try with Straight table.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
So then can I hide the months which are after the current month? for example, not to show may, june, july, etc.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yup, but that will depend on your conditional

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
talk is cheap, supply exceeds demand
