expand pivot table

[#1]

hi friends

i have a pivot table that has some dimensions.so it is shown with some + symbols that i should click on to open them. i want not to see these + symbols and have dimensions always expanded. i dont want to use a straight table instead because: 1. i can't have partial sums, 2. i dont want to see repeated dimension values.

any one can help me?

thanks

[tresesco · Accepted solution]

Presentation tab->'Always fully expanded'

[ashfaq_haseeb]

Hi

Go To chart Properties --> Presentation tab --> Select Always fully Expanded.

Regards

ASHFAQ