Create TreeView in Pivot Table

[Anonymous]

Hi,

I have a question about changing the design of pivot table.

I have a pivot table like this:

I want to change the design to a treeview design like this one:

A

     A

     B

     C

     D

     E

B

     A

     B

     C

So when i click the expand (+ symbol) the chart will expand under the person not beside the person dimension.

Is it possible to make it ?

Really need your help, Thanks

[avinashelite]

As per my knowledge expanding under the header is not possible

[jonathandienst]

On Chart Properties | Style, check the Indent Mode checkbox.

[Anonymous]

Hi Jonathan,

thanks for your suggestion, it works perfectly, but i have a problem when i move the layout.

I have 3 dimension (Person, Area, Brand) and 2 expression (Qty1, Qty2) When i move the Qty beside Area, the Area column not show. Is it possible to make the area column shown again ?

I also attach my qvw file

The result i Expect is like this:

                                                  Brand A          Brand B          Brand C

Person A

          Area1    

                    Qty1                         10                    ....               ....

                    Qty2                         10                    ....               ....

          Area2

          Area3

          .......

Thanks