ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Pivot table grouping question (https://www.excelbanter.com/excel-worksheet-functions/161004-pivot-table-grouping-question.html)

Jason[_7_]

Pivot table grouping question
 
Hi,

I have a pivot table which I am trying to create. I have grouped some parts
together and I am trying to get the grouped field to show on each line
instead of just once. The exaample below is what I am working with. I would
like the salesman field to appear on each line.

The pivot looks like:

Salesman Customer
ABC1 smith
jones
bates
ABC2 name1
name2
etc

Please can you help?

Many thanks

Jason


Dave Peterson

Pivot table grouping question
 
Check your other post.

Jason wrote:

Hi,

I have a pivot table which I am trying to create. I have grouped some parts
together and I am trying to get the grouped field to show on each line
instead of just once. The exaample below is what I am working with. I would
like the salesman field to appear on each line.

The pivot looks like:

Salesman Customer
ABC1 smith
jones
bates
ABC2 name1
name2
etc

Please can you help?

Many thanks

Jason


--

Dave Peterson


All times are GMT +1. The time now is 04:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com