(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?
