Change pivot table format and count

[PJenkins]

Hello,

I would like to have a pivot table that will count the number of responses I get for a certain question

For example on the attached book I would like it to look something like:

a
blue 1
red 1
yellow 1
green 1
aa
green 2
yellow 1

and so on, I am sure this is possible just not sure how to make it happen. Any help is appreciated.

Thank you!

[AlKey]

Please see attached and let me know if this is what you want.

[PJenkins]

Yes, thank you! Will you please let me know how this is done?

[AlKey]

Yes, thank you! Will you please let me know how this is done?

Thanks for the feeback!

------

First, click on the pivot table and go to Options and click on Field List. Here you can see how windows were arranged. Then go to Design tab and go to Report Layout and select Show in Tabular Form.

[PJenkins]

Great! Thanks again for being helpful!

[AlKey]

You're welcome

Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).