Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello dear friends,
I need to use a pivot table, and I would like that all dimensions have by default the minus icon, How to do this?
Below a print screen of my table :
Thank you for your continued support.
then i guess you need to manually expand all
Go to chart properties >Presentation tab> Select Always fully expanded
pivottable-->rightclick-->-presentation-->always fully expanded option
The pb, whene I do that the minus/plus icon will disappear, see bellow :
I would like the result to be like that :
Hi master_student,
Can you please say what is your exact need?
then i guess you need to manually expand all
If you nee this way then you have to do it manually....
Do it manually and save the report.
Thanks, I i thought there's a more Quick solution any way I need to create a new table style, do you know how?
Hi guys, I find a solution, just right clik on the field name and click expand all :