Position of dimensions in Pivot table

[#1]

Hi

Attached is my Excel which I want in a Pivot Table. I want the dimensions of a Pivot in the same row like Excel, is that possible in QLIKVIEW?

I want my Pivot to look like this

Group 1     60

     Team 1

     Team 2

     Team 3

Group 2   150

     Team 1

     Team 2    

     Team 3

I have multiple levels in my application and this is just an example. I want all children to net up to the parent level based on a flag

TIA

[oscar_ortiz]

You'll need to first fill in the blanks for your Name field:

Data:

LOAD

  Name,

  Teams,

  Players

FROM

[test.xlsx]

(ooxml, embedded labels, table is Sheet1, filters(

Replace(1, top, StrCnd(null))     //     Code to fill in the blanks

));

Then use your Name and Teams as Dimensions and your Players will be used in your expression to complete your pivot table.

[trdandamudi]

See if the attached is acceptable:

[#4]

Thanks for your help.

I am looking at the out to be something like this

Group 1

     Team 1     60

     Team 2

     Team 3

Group 2

     Team 4     150

     Team 5

     Team 6

Team is one dimension and group is another dimensions. I have one more dimension under team. Is this possible in QLIKVIEW to group one dimension under the other and aggr values at the top