Pivot table, unfold automatically?

[#1]

Hi,

Merry Christmas to the whole community !!!

I have two questions.

First, with a pivot table, is it possible to hide symbols "+" and "-"?

Second, is it possible to unfold automatically a pivot table?

For exemple, i have this table :

I want this result but automatically (without clicking all "+")

Thanx for your help,

[arulsettu · Accepted solution]

hi

try in properties -> presentation -> enable always fully expanded

[#3]

go to the properties of the chart and under presentation tab check the option "Always fully expended",it will expand the chart

[#4]

Ok, thank you, i was sure that it was just an option, but i had not found it...

Thank you.

[amit_saini]

Hi,

Unfold you can control from here:

Presentation Tab-> Select your dimension or expression -> Check -Uncheck "Always Fully Expanded" option

I don't think so you can hide + and - in pivot table. Second option you can use straight table .

Thanks,
AS

[#6]

Hi,

When I Check "Always Fully Expanded" from all fields, symbols "+" and "-" are hidden automatically.

[amit_saini]

Yes you are right.

Thanks,
AS