Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Can anyone tel is it possible to vertically expand and collapse the Dimensions in Pivot table?
What do you need to do? explain a little more please!!!
Hi,
Omar is right, do you mean have your measures on the left and you dimension on top ? Or, do you want the table which looks like Omar's example ?
Quentin
Hi Omar & quentin.bruno,
My example is simar to Omar's But In Omar's example dimensions are horizontally expand and Collapse and I need the same in verically.
see the attachments for Example
Hi,
You can easily drag and drop your dimensions in your pivot table. You just have to go in your table properties then in the presentation tab and allow pivoting.
Next, just click on your dimension and drag and drop it wherever you want.
Quentin
Hoooo I see!!! check the function CROSSTABLE maybe is what you need !!!!!! I make some examples with that function!!!! or you can UPLOAD some excel to look we can do....