How to create a pivot table with multi levels of headers?

[msmichael]

Hi,

I have raw data in the attached qvw file.

I need to count how many prodId marked as "Senior" for each team in each region (Global vs EMEA)  , and same to Non-Senior ones.

The final table should look like below,

How can I get such a table in QV?

Thanks,

Michael

[Frank_Hartmann · Accepted solution]

see attached file.

hope this helps

[Lisa_P]

Hi Michael,

I have almost got it, but the totals are broken out by Senior/Non-Senior, see attached.

[msmichael]

Thank you so much Frank! I appreciate it!

[msmichael]

Hi Lisa,

Thank you very much for the solution. I might need this solution also.