hide/remove certain parts of pivot table

[tryingtoexcelatexcel]

Hi All,

In my pivot table (attached file) I would like to show net sales for 2017 and 2018 as well as the target vs net sales.

But in the 2017 columns I would like to hide "target" and "2018 vs Target" while keeping these columns in the 2018 columns. Is this possible?

Thank you very much.

[kersplash]

Withdrawn - attachment added.

[tryingtoexcelatexcel]

Hi Kersplash, yes I just noticed the attachment is too large so I've made it smaller and have attached it.

[kersplash]

You could just hide columns C & D.

[tryingtoexcelatexcel]

Hi Kersplash, but what if I wanted to expand the pivot table? Is there a different way around this?

[rorya]

Do you have Power Pivot available to you?

[tryingtoexcelatexcel]

I do not. I wish I did but I only have the regular pivot tools available.

[rorya]

In that case hiding columns I think is your only real option. You could always automate it.

[tryingtoexcelatexcel]

i see, then thank you both very much for the advice.

[stasinek]

Look at this solution

[tryingtoexcelatexcel]

stasinek, thinking outside the box! thanks that works well.

[tryingtoexcelatexcel]

although Im not sure why Nelson Niu is the only person that shows the different months

[stasinek]

Place the cursor on the first column. Right mouse button - expand the entire field