Multi layer Cross Tab preparation with tabular data in excel

[Pinaki Chatterjee]

I have a table in excel. The table has dimension as Country, City, Zip code and sales person, I want group by them by in row by sales value and QTY and in the column the Year and corresponding period should reflect. Values in the cells will be sum of rev by period and then again sum of qty by period. Also each segmentation should have sub total.

The output should look like
Year Year
Month 1 Month 2 Month3 Month1 Month2 Month3
Country City Zip Code Executive Sum by Rev Sum by Qty
A A1 A11 X
A12 Y
A2 A21 Z
A22 V

 

[Fluff]

Duplicate Group and aggregate data

Please do not post the same question multiple times.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).