Help With Pivot Tables

[Mike Lewis]

Hello,

I am in need of some help. I have a list after running a macro that brings
back the "question #" (Column 1), Buyer Group decision to the question
(Column 2), which is in the form of a number between 1 -5. The macro runs
each survey, so there could be 7 columns with "question #" and 7 columns of
"buyer Group decision to the question" if there are 7 returned survey's.

So, how can I automatically add all these together, so that a total number
is reported for each question. So if there are 6 buyer groups labeled
"Males" and they respond to question #1 with 5, then I would like to have 30
totaled for me in the pivot report, but I would like to have this automatic.

Any thoughts...I hope this is clear.

 

[paul.robinson]

Hi
Have your data in 3 columns:
Buyer group Question Question response

In your pivot table have Buyer group in the Row Area, Question in the
Column Area and Response in the Data Area. The default action in the
Data Area is to count and you want to sum. Right click in the Data
Area, choose Field Settings... and set Summerize by to Sum.

regards
Paul