Expand (or not) all dimension values without editing

[#1]

Hi,

let assume I have a pivot table with several dimensions at the left side of the data square, that is, as a rows dimensions. Each dimension includes many values of the depending dimension so if I choose 'Allways expanded' it could be too long.

Because the table is for a user who will not edit pivot table properties, I would need a solution to expand several choosen values or all the values but without accessing the table properties. I suppose I need a kind of object or something.

Is it possible?

Thanks

[#2 · Accepted solution]

Hi

Just chucking a few ideas around....

1.  I'm assuming the end user option to right click and click on Expand All is not something you like because they would need to do that for all dimensions individually. This is the first option and requires no work.

2.  You could have two straight tables, one with only one dimension and one with all dimensions. The one with one dimension could be shown as a default with a show condition as (for eg) VariableName=1, then have a button with an action to change the variable to 2 (the text on the button could say.... View all dimensions). The second straight table has a show condition of VariableName=2 and shows all dimensions.

3.  The same as above could be used with two pivot tables (or a straight table and a pivot table) with the presentation property of the second pivot with the setting Always Fully Expanded set to On.

Hope one of these helps.

Nigel.

[#3]

Perfect, incredibly the solution is the first one but the second is solving the following question I was about to post. Thanks Nigel.

[#4]

My pleasure.....