pivot table layout

Giganews Newsgroups
Subject: pivot table layout
Posted by:  appleknocker
Date: Wed, 17 May 2006

I can't get the table to layout the way I want it to

Data

Row Col
      a b c d e f
aa  1 1 1 1 1 1
ab  2 2 2 2 2 2
aa  3 3 3 3 3 3
ab  4 4 4 4 4 4
ac  5 5 5 5 5 5
af  6 6 6 6 6 6

I want to group the rows that are common and sum the colums in like rows.
The report result (summing the columns) should look like this

      a b c d e f
aa  4 4 4 4 4 4
ab  6 6 6 6 6 6
ac  5 5 5 5 5 5
af  6 6 6 6 6 6

I do I make this happen in pivot table?

Jim Roth

Replies