Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try with 'Indent Mode' in the Style tab as shown here: Creating a Tree view in a Pivot table
Check this document: Hierarchies
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.
Try with 'Indent Mode' in the Style tab as shown here: Creating a Tree view in a Pivot table
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:
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.