Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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,
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,
Thanks Oleg.
That is a good idea.