Pivot tables

[Sapell]

I am analyzing a table with lots of text and no numbers and i am using pivot tables. Therefore i use the "count" command to aggregate say number of people who say that they 'agree" in a survey for a question x . HOWEVER , i noticed that once i start adding other fields for disagree, agree somewhat.. etc, excel gives me the same totals for each category which i know is absolutely wrong. how can i summarize categorical variables with text using pivot tables without to avoid the above ????

 

[Marcelo Branco]

Hi and welcome to Mr Excel

Could you provide a data sample (raw data you used to create the PVT)?

Have you updated the data source of your Pivot Table after inserting new data?

M.

 

[mfexcel]

From your description, it's a high chance that you've put "Agree", "Disagree"... as different fields. And you summarized the data by Count of Question, for example. Right? You will get the same number as the Count of Question remains unchanged.
You should have different fields in the data area: "Count of Agree", "Count of Disagree", etc...

I am analyzing a table with lots of text and no numbers and i am using pivot tables. Therefore i use the "count" command to aggregate say number of people who say that they 'agree" in a survey for a question x . HOWEVER , i noticed that once i start adding other fields for disagree, agree somewhat.. etc, excel gives me the same totals for each category which i know is absolutely wrong. how can i summarize categorical variables with text using pivot tables without to avoid the above ????

 

[Sapell]

Well i tried that and i still get totals that dom not look right. they may vary by one unit but if you actually used a "countif" function you realize that the count is wrong! Anyway can i send you my table and you check it out ??

 

[Sapell]

Oh how do i attach a pivot table ?? on this forum