View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
William Horton
 
Posts: n/a
Default Pivot Table Row ?Grouping? Question

I'm a little confused with your pivot table layout. Are what you have as 1,
2, 3, 4, and 5 different fields? You can group items in a pivot table but
you can't group fields. I guess I don't understand the question correctly.

"Tim Whitley" wrote:

I have the following pivot table:

1 2 3 4 5
Totals

S (188.14)
05 (3.74)
EZ (3.74)
07 (3.20)
EZ (3.20)

The row levels 07 and EZ are always the same values and I would like to get
the data on the same row level however I can't figure out how to do this.
This section is a small subsection of a much larger table so it's isn't
workable to copy as values and paste.