Collapse all not working properly in pivot

[Anonymous]

Collapse all only collapse rows of particular column.Is it possible to collapse all the rows of all columns in pivot

Thanks,

Kiran

[alexandros17]

go on the column name and then click collapse otherwise you collapse only the value on which you are

[danieloberbilli]

have a look here:

[Anonymous]

but this applied to individual column right?Is there any way to collapse all columns in single click.

[Anonymous]

I dont want to remove functionality of collapse all.

Let me give more clear idea suppose I have 3 dimension in my pivot out of 1st 2 are expanded.

Now I want collapse all in single click is not get possible.

Is there any trick to do that

[#6]

Hi,

If you right click on first column and select collapse all then all the columns will collapse on single click.

[#7]

Hi,

Have a look at an example which I have created. I am giving snapshots of it.

Cheers

Saurabh

[alexandros17]

If you expand (as I told before) all the columns then you collapse on the first column each time you expand again it will automatically remember that all other columns are yet expanded

Let me know

[Anonymous]

According to me it only collapse 1st column and hiding other columns.

When u again expand 1st column ,2nd column is allready in expanded state as it was previous before you do collapse all.

[#10 · Accepted solution]

Hi Kiran,

It seems like only this is left-

1.Create the pivot table

2. Add a bookmark with "Include Layout State" option selected.

3. Collapse all the columns and create another bookmark with "Include Layout State" option selected.

4. Now, collapse and expand will take place with a single click without changing presentation tab settings.

Cheers

Saurabh