grandevouz
New Member
- Joined
- Jan 24, 2012
- Messages
- 2
Good Morning,
I need help regarding achieving the same results from a table using CountIFS into a Pivot Table.
Let's say our company sends out surveys to clients regarding 2 similar products; Brand A & B.
Now customers are asked Questions A to Question J; for each question they have to rate Brand A and Brand B from a scale of 1 to 7 with 7 as the highest.
Now how do I achieve the same results using a Pivot Table?
Here's my raw data:
<tbody>
</tbody>
...and this is the table I've created to count how many customers rated Question A to J with 1 to 7:
<tbody>
</tbody>
I need help regarding achieving the same results from a table using CountIFS into a Pivot Table.
Let's say our company sends out surveys to clients regarding 2 similar products; Brand A & B.
Now customers are asked Questions A to Question J; for each question they have to rate Brand A and Brand B from a scale of 1 to 7 with 7 as the highest.
Now how do I achieve the same results using a Pivot Table?
Here's my raw data:
Question A | Question B | Question C | Question D | Question E | Question F | Question G | Question H | Question I | Question J | Date | Brand |
2 | 1 | 2 | 3 | 7 | 3 | 3 | 4 | 7 | 1 | 10-Jul | Brand A |
3 | 7 | 2 | 6 | 2 | 3 | 4 | 4 | 4 | 6 | 10-Jul | Brand A |
1 | 7 | 2 | 4 | 4 | 3 | 7 | 6 | 1 | 4 | 10-Jul | Brand A |
7 | 2 | 1 | 6 | 4 | 3 | 3 | 4 | 7 | 2 | 10-Jul | Brand A |
6 | 1 | 3 | 4 | 6 | 5 | 6 | 6 | 7 | 3 | 10-Jul | Brand A |
5 | 1 | 2 | 3 | 2 | 2 | 1 | 2 | 6 | 5 | 10-Jul | Brand A |
4 | 4 | 7 | 6 | 3 | 7 | 4 | 7 | 6 | 5 | 10-Jul | Brand A |
3 | 2 | 5 | 1 | 4 | 5 | 1 | 6 | 7 | 7 | 10-Jul | Brand A |
3 | 7 | 3 | 7 | 4 | 5 | 4 | 1 | 1 | 3 | 10-Jul | Brand A |
1 | 1 | 3 | 7 | 7 | 6 | 5 | 7 | 2 | 5 | 10-Jul | Brand A |
2 | 7 | 6 | 5 | 4 | 2 | 4 | 2 | 4 | 5 | 10-Jul | Brand A |
1 | 2 | 4 | 5 | 7 | 2 | 5 | 4 | 3 | 6 | 11-Jul | Brand A |
1 | 2 | 3 | 5 | 6 | 7 | 5 | 2 | 2 | 5 | 11-Jul | Brand A |
1 | 5 | 3 | 7 | 5 | 7 | 3 | 1 | 6 | 1 | 11-Jul | Brand A |
5 | 4 | 2 | 7 | 5 | 1 | 5 | 7 | 2 | 7 | 11-Jul | Brand A |
5 | 7 | 4 | 4 | 5 | 5 | 3 | 7 | 2 | 3 | 11-Jul | Brand A |
7 | 7 | 5 | 6 | 5 | 6 | 2 | 5 | 2 | 1 | 11-Jul | Brand A |
6 | 5 | 5 | 1 | 4 | 3 | 2 | 5 | 7 | 1 | 11-Jul | Brand A |
3 | 7 | 2 | 3 | 7 | 1 | 3 | 1 | 5 | 5 | 11-Jul | Brand A |
6 | 5 | 6 | 4 | 7 | 3 | 3 | 6 | 2 | 6 | 11-Jul | Brand A |
4 | 1 | 3 | 1 | 5 | 3 | 5 | 3 | 3 | 6 | 11-Jul | Brand A |
4 | 2 | 4 | 5 | 5 | 4 | 7 | 2 | 5 | 4 | 11-Jul | Brand A |
5 | 1 | 2 | 3 | 7 | 3 | 1 | 4 | 4 | 5 | 11-Jul | Brand A |
6 | 5 | 3 | 5 | 5 | 6 | 5 | 5 | 1 | 4 | 11-Jul | Brand A |
6 | 7 | 6 | 5 | 6 | 2 | 4 | 7 | 2 | 5 | 12-Jul | Brand B |
4 | 1 | 7 | 6 | 5 | 7 | 3 | 6 | 3 | 3 | 12-Jul | Brand B |
1 | 2 | 2 | 7 | 5 | 3 | 7 | 4 | 5 | 1 | 12-Jul | Brand B |
6 | 7 | 2 | 5 | 4 | 2 | 2 | 7 | 4 | 2 | 12-Jul | Brand B |
3 | 2 | 3 | 2 | 1 | 4 | 1 | 3 | 4 | 2 | 12-Jul | Brand B |
2 | 6 | 4 | 5 | 1 | 5 | 1 | 2 | 5 | 3 | 12-Jul | Brand B |
2 | 7 | 2 | 7 | 1 | 6 | 5 | 5 | 4 | 2 | 12-Jul | Brand B |
3 | 3 | 6 | 7 | 1 | 2 | 1 | 3 | 6 | 4 | 12-Jul | Brand B |
1 | 4 | 2 | 5 | 1 | 5 | 5 | 2 | 7 | 6 | 12-Jul | Brand B |
7 | 1 | 4 | 3 | 7 | 3 | 6 | 4 | 2 | 5 | 12-Jul | Brand B |
2 | 1 | 4 | 4 | 4 | 3 | 3 | 7 | 7 | 5 | 12-Jul | Brand B |
2 | 3 | 1 | 6 | 5 | 5 | 3 | 1 | 6 | 6 | 12-Jul | Brand B |
3 | 1 | 7 | 5 | 4 | 2 | 6 | 4 | 2 | 2 | 12-Jul | Brand B |
7 | 4 | 7 | 6 | 1 | 1 | 6 | 6 | 2 | 1 | 12-Jul | Brand B |
7 | 6 | 1 | 2 | 5 | 6 | 6 | 1 | 3 | 2 | 13-Jul | Brand B |
7 | 4 | 7 | 1 | 1 | 1 | 5 | 1 | 7 | 4 | 13-Jul | Brand B |
1 | 7 | 3 | 2 | 3 | 1 | 5 | 4 | 4 | 4 | 13-Jul | Brand B |
2 | 1 | 1 | 1 | 7 | 1 | 5 | 7 | 5 | 4 | 13-Jul | Brand B |
3 | 7 | 3 | 1 | 1 | 6 | 3 | 1 | 1 | 3 | 13-Jul | Brand B |
4 | 7 | 3 | 5 | 7 | 4 | 4 | 1 | 4 | 4 | 13-Jul | Brand B |
6 | 4 | 2 | 2 | 1 | 4 | 6 | 5 | 5 | 6 | 13-Jul | Brand B |
6 | 5 | 1 | 7 | 4 | 7 | 5 | 5 | 6 | 4 | 13-Jul | Brand B |
6 | 4 | 2 | 7 | 6 | 5 | 4 | 1 | 4 | 5 | 13-Jul | Brand B |
7 | 7 | 7 | 3 | 4 | 2 | 2 | 3 | 5 | 6 | 13-Jul | Brand B |
7 | 7 | 6 | 7 | 2 | 4 | 3 | 5 | 1 | 2 | 13-Jul | Brand B |
7 | 4 | 4 | 5 | 7 | 3 | 3 | 3 | 4 | 1 | 13-Jul | Brand B |
4 | 6 | 3 | 6 | 6 | 7 | 5 | 6 | 7 | 4 | 13-Jul | Brand B |
<tbody>
</tbody>
...and this is the table I've created to count how many customers rated Question A to J with 1 to 7:
Brand A | ||||||||||
Question A | Question B | Question C | Question D | Question E | Question F | Question G | Question H | Question I | Question J | |
1 | 5 | 6 | 1 | 3 | 0 | 2 | 3 | 3 | 3 | 4 |
2 | 2 | 5 | 7 | 0 | 2 | 3 | 2 | 4 | 6 | 1 |
3 | 4 | 0 | 7 | 4 | 1 | 8 | 6 | 1 | 2 | 3 |
4 | 3 | 2 | 3 | 4 | 6 | 1 | 4 | 5 | 3 | 3 |
5 | 4 | 4 | 3 | 5 | 7 | 4 | 6 | 3 | 2 | 7 |
6 | 4 | 0 | 2 | 4 | 2 | 3 | 1 | 4 | 3 | 4 |
7 | 2 | 7 | 1 | 4 | 6 | 3 | 2 | 4 | 5 | 2 |
Brand B | ||||||||||
Question A | Question B | Question C | Question D | Question E | Question F | Question G | Question H | Question I | Question J | |
1 | 3 | 5 | 4 | 3 | 9 | 4 | 3 | 6 | 2 | 3 |
2 | 5 | 2 | 6 | 4 | 1 | 5 | 2 | 2 | 4 | 6 |
3 | 4 | 2 | 5 | 2 | 1 | 4 | 6 | 4 | 2 | 3 |
4 | 3 | 6 | 4 | 1 | 5 | 4 | 3 | 4 | 7 | 7 |
5 | 0 | 1 | 0 | 7 | 4 | 4 | 7 | 4 | 5 | 4 |
6 | 5 | 3 | 3 | 4 | 3 | 3 | 5 | 3 | 3 | 4 |
7 | 7 | 8 | 5 | 6 | 4 | 3 | 1 | 4 | 4 | 0 |
<tbody>
</tbody>