mikeannetta
New Member
- Joined
- Oct 6, 2015
- Messages
- 13
- Office Version
- 2019
- Platform
- Windows
Win 10 - Office Professional Plus 2019
I worked with Pivot Tables for years, however I've been retired for the last 5.
I have a rather large Survey that I created.
I have many questions with (Yes-No-Sometime) answers to them.
Each person has an unique #
How can I create a pivot table that that looks something like:
<tbody>
</tbody>
My excel data looks like (with an ID)
<tbody>
</tbody>
I am not familiar with the Data Modeling and PowerPivot. Can I do this without that? How
If I need to use Data Modeling / PowerPivot any suggestion here would help..
Thanks,
Mike
I worked with Pivot Tables for years, however I've been retired for the last 5.
I have a rather large Survey that I created.
I have many questions with (Yes-No-Sometime) answers to them.
Each person has an unique #
How can I create a pivot table that that looks something like:
Question | # Yes | # No | # Sometimes |
I felt anxious | 113 | 85 | 204 |
I felt nauseous | 334 | 41 | 27 |
<tbody>
</tbody>
My excel data looks like (with an ID)
I felt anxious | I felt nauseous | # of Symptoms – Yes (Calculated Field) | # of Symptoms – Sometimes (Calculated Field) | # of Symptoms – No (Calculated Field) |
Yes | Yes | 2 | 0 | 0 |
No | No | 8 | 3 | 18 |
Yes | No | 7 | 0 | 22 |
0 | 0 | 0 | ||
0 | 0 | 0 | ||
0 | 0 | 0 | ||
No | No | 4 | 2 | 23 |
No | No | 5 | 5 | 19 |
Sometimes | No | 8 | 6 | 15 |
No | No | 7 | 5 | 17 |
Sometimes | Sometimes | 4 | 8 | 17 |
0 | 0 | 0 |
<tbody>
</tbody>
I am not familiar with the Data Modeling and PowerPivot. Can I do this without that? How
If I need to use Data Modeling / PowerPivot any suggestion here would help..
Thanks,
Mike