Leveling in Pivot

[#1]

Hi,

I am developing a report based on a pivot table.

I have Level1, Level2, Level3, ... as dimensions.

what should I do to get all these levels fit within on column instead of normal drill down which creates a new column of each sub level.

Thanks for help.

[jvitantonio]

Hi,

I'm not sure what you are trying to achieve, but you can either use a "Straight Table" instead of a pivot, or check the option "Always expanded" in the properties.

However, if what you want is to have all 3 levels in one column, then create a customized dimension like this:

=Level1&Level2&Level3

Best,

JV

[PradeepReddy]

Hi,

If I unserstand the requirement in rightway, you want to show case the pivot table data in expandable mode,always.

For this,  rigt click on the dimension column select the "expand all " option.

Thanks,

Pradeep

[#4]

Thanks for your reply.

I am trying to group all dimensions in one column. I want the dimension to drill down within the same column.

If I have 9 levels, when set "always expanded" to true, I will get 9 different column.

Normal drill down:

L1     L2     L3     L4

         L2     L3     L5

L1     L2     L3     L6

.....

What I want:

L1

   L2    

     L3

          L4

          L5

... all within the same column.
drilling down as a tree.

[Anonymous]

You can use cyclic group option but limitation is that you can see only one level at time.

What you are saying is default behavior of pivot.if you want to see more that one dim it will create new column at each time.

Thanks & Regards

Kiran Kokade

[jvitantonio]

Hi Elie,

you can't get this view in a pivot table.

You can only achieve a tree view in a list box. Please look for "Tree View in list boxes" in the help.

Thanks,

JV