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