View Single Post
  #5   Report Post  
Barb R.
 
Posts: n/a
Default

OK, here is an attempt at an example without real data
Metric 1 Metric 2 Metric 3 Metric 4
Group 1
Group 2
Group 3
Group 1
Group 2
Group 3
Group 1
Group 2
Group 3
Group 1
Group 2
Group 3

I want to sum metric 1, 2, 3, etc. or each Group. My pivot table looks
like this:

Group 1 Metric1
Metric2
Metric3
Group 2 Metric1
Metric2
Metric3
Group 3 Metric1
Metric2
Metric3

And I want
Metric 1 Metric 2 Metric 3
Sum Sum Sum
Group 1
Group 2
Group 3

"Bernie Deitrick" wrote:

Barb,

If you could post a small table of your data, the result you get, and the
result you want, then it would help clarify what you mean.

HTH,
Bernie
MS Excel MVP


"Barb R." wrote in message
...
Tried that. It didn't work. I have data for 10-12 subprograms

summarized
as data for several metrics. I want to summarize each metric by

subprogram.
If I put the metric at the top of the column, it summarizes it by value

for
the metric.

Did I miss something?

I opted to use the "Transpose" function, but it's not as elegant as I'd

like.

Barb Reinhardt

"Bernie Deitrick" wrote:

Barb,

Drag the Data Value button to the top of the columns.

HTH,
Bernie
MS Excel MVP


"Barb R." wrote in message
...
I have a case where I have a pivot table one ROW designator with about

20
values. I also have about 10 values. What I want to do is have the
data
listed as

ROW 1 Data value 1 Data value 2 Data value 3 instead of

Row 1 Data value1
Data value2
Data value3
Row 2 Data value1

etc.

Is there a way to do this that isn't tedious?

Thanks in advance,
Barb Reinhardt