Issue with Pivot Table (Expand)

[#1]

Hi everyone, my english is not so good but i hope you can understand me.

I have a table where i need to display a lot of data. It's annoying to have to expand dimension by dimension, then, can i predetermine that a pivot table have the first 2 dimensions expanded, and the rest with de expansion icon [+], to expand manually?

Thank you all and i hope your answers.

[#2 · Accepted solution]

Luciano,

In the pivot table right click on first dimension and select expand all. Do the same for second dimension also. Save the document and now when opend the first two dimensions are expaned and rest are collapsed.

Regards,

Kiran Rokkam.

[#3]

Thanks, this solve my problem.

Regards.

Luciano Muñoz.-