Hi all,
There are 2 actions 'expand all', 'collapse all' on a pivot table.
When doing 'expand all', all the lines and columns are expanded.
Sometime, we just need to expand all on columns, or expand all on lines. So we have :
* to 'expand all', and then click on '-', '-', '-' etc. on all the lines if we want to expand only columns,
* to 'expand all', and then click on '-', '-', '-' etc. on all the columns if we want to expand only lines,
I would like to have theses 2 additionnal possibilities on expand / collapse options.
Olivier W.
Business & Decision Bordeaux