Pivot table grouping question

J

Jason

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
 
D

Dave Peterson

Check your other post.
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

pivot table grouing question 1
Pivot Table Grouping 1
Repeating rows in pivot table - how to 2
Format a Grouped Date in a Pivot Table 2
Pivot Table sorts date as Alpha, not as Date 6
Grouping Date Data in a Pivot Table 1
Sorting the pivot table field list 4
Pivot Table: Ranking Items of a Field 8

Top