pivot table

[adiarnon]

hi,

i have a pivot with 4 dimensions

i want that if i open the first dimension the second and the third will open

how can i do it?

[Gysbert_Wassenaar]

You can't. You can only expand/collapse all dimensions at once or manually expand each dimension value one at a time.

[nagarjuna_kotha]

Hi Adi ,

Its not possible

[HirisH_V7]

Hi ,

I think one way is to include two dimensions at Backend ,

 Customer & '-' &Product as New,

In Front end you can use this as a single dimension in Frontend,

Hope this helps as a way,

Thanks,

Hirish

[settu_periasamy]

May be like this you need?

=>  'Expand All' - for your 3 dimensions.(each dimension you should give 'Expand All')

=> In the First Dimension -> Give 'Collapse All'  -> Save your app.

Now, if you click your 1st dimension, till 3rd dimension will open.

Not sure, this is your need. just i checked.

[adiarnon]

but it will change if the user will change the pivoting

right?

[adiarnon]

tnx,

and what about expression?

[Kushal_Chawda]

You can't do this. You can do expand & Collapse or expand the dimension one by one