Pivot Tables,

[#1]

Hey Guys,

I have created a pivot table but I don't need all the columns to pivot just the first few ones. Is there a way to tell which column needs to pivot?

Or if there is a way not to have the + - button show.

[Oleg_Troyansky · Accepted solution]

Hi Kristen,

unfortunately, no - it's "all or nothing"... As a work around, you might want to combine (concatenate) some dimensions together - then you'll have less +/- signs...

cheers,

[#3]

Thanks Oleg.

That is a good idea.