Pivot Table Report Row labels for each item report

[Memar]

Can I use a pivot table to get the result shown below? How can I get the row labels for each sales agent and have add a blank row after each sales agent.

Sales person Name 1	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
Product Item Number	10	20	15	13	12	10	20	10	11	15	16
Product Item Number	10	5	11	15	12	6	18
Product Item Number	10	6	10	12	12	5	12	12
Product Item Number	10	2	8	10		3	10
Product Item Number	10
Total Current Region Product	50	33	44	50	36	24	60	22	11	15	16	0
South East Product
Product Item Number	10	15	5	6	5	3
Product Item Number	20	20	2	4	2
Product Item Number			5		2
South East Product Total	30	35	12	10	9	3	0	0	0	0	0	0
North West Product
Product Item Number	10	12	5	10	8	12	10	11	10
Product Item Number	20	10	12	10	5	6	8	10
Product Item Number	10	8
North West Product Total	40	30	17	20	13	18	18	21	10	0	0	0
TOTAL	120	98	73	80	58	45	78	43	21	15	16	0

<colgroup><col><col span="12"></colgroup><tbody>
</tbody>

Sales person Name 2	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
Product Item Number	10	20	15	13	12	10	20	10	11	15	16
Product Item Number	10	5	11	15	12	6	18
Product Item Number	10	6	10	12	12	5	12	12
Product Item Number	10	2	8	10		3	10
Product Item Number	10
Total Current Region Product	50	33	44	50	36	24	60	22	11	15	16	0
South East Product
Product Item Number	10	15	5	6	5	3
Product Item Number	20	20	2	4	2
Product Item Number			5		2
South East Product Total	30	35	12	10	9	3	0	0	0	0	0	0
North West Product
Product Item Number	10	12	5	10	8	12	10	11	10
Product Item Number	20	10	12	10	5	6	8	10
Product Item Number	10	8
North West Product Total	40	30	17	20	13	18	18	21	10	0	0	0
TOTAL	120	98	73	80	58	45	78	43	21	15	16	0

<colgroup><col><col span="12"></colgroup><tbody>
</tbody>

thanks for your help and time

 

[Worf]

• Can you post a sample of your source data?
• I would put the salesperson on the filters area. If you want to see them simultaneously, duplicate the pivot table.