expand associations under same column

[razvan_brais]

Hey guys.

I have 3 table created from excel file.

Level1:

LOAD ACC,

     DESC

FROM

[excelFile]

(ooxml, embedded labels, header is 1 lines, table is [Sheet ]);

Level2:

Load

  DESC,

     Column1

     FROM

[excelFile]

(ooxml, embedded labels, header is 1 lines, table is [Sheet ]);

Level3:

Load

      Column1,

     Column2,

     Column3

     Column4

  FROM

[excelFile]

(ooxml, embedded labels, header is 1 lines, table is [Sheet ]);

Using these 3 tabel I created 3 groups as :

Group1: DESC

Group2:Column1,

Group3:

Column2,

     Column3

     Column4

All these info I inserted in a Pivot Table as dimmensions.

So now when I clik on a account , I will see the first Group info , I click + and see Group2 assocciated with the first group in a third column and so on. What I want to do is that I want to have a Pivot Table , with two Columns.

First column to be ACC and second Column to contain all of the three groups that are associated with the account.

I want that my table to look something like this

Column1	Column2
1	Group1      -Group2            -Group3
2	Group1      -Group2            -Group3

With the posibility of expanding each group info. Is there any way to make this happen?

Thank you

[tresesco]

Check this document: Hierarchies

[razvan_brais]

Hy there. I have created the tables using hierarchies but , what I want to achieve is that i want that hierarchy to be in a column from a pivot table , such as a treeview from a listbox. I couldn`t find any solution on that.

[tresesco · Accepted solution]

Try with 'Indent Mode' in the Style tab as shown here: Creating a Tree view in a Pivot table

[razvan_brais]

Nope , this isn`t what i`m looking for. I want to have on the first column the unique ID such as UserID. and when I click on + in the second column I would like to have The first level associated for that ID , then when I click on + to show the next level and so on. Something like this:

[razvan_brais]

After a few hours of researching ) ) I found out that what you suggested is the correct answer , all what I had to do is to modify subtotal position , and I obtained what I needed.

Thank a lot.