Removing null columns in pivot table.

[nsm1234567]

Hi there,

I'm wondering if there is a way to manipulate a pivot table for a report I'm trying to build.  If you look at the attachment (also see screenshot below), you'll see I've built a pivot table with report headers.  Ideally, I'd like to display the Week, Month and Year columns for all the headers except "Contributed Growth."  For "Contributed Growth" I only want to show the month column.  In other words, the columns that reflect as "null" I want to not display.  I've tried a few things without success.  Is this possible?

[Anonymous · Accepted solution]

Hi,

I tried doing a valuelist for this one.

Dimensions:

1. Business Unit

2. ReportHeader

3.=ValueList('Week','Month','Year')

Expression:

=if(ReportHeader='Contributed Growth', if(ValueList('Week','Month','Year')='Month', sum([Business Unit])),

sum([Business Unit]))

I'm not sure if there are better ways

[nsm1234567]

Thanks a lot, I was able to get a variation of that to work in my app.

Thanks for the assistance.