SOLVED

Pivot Table Not Working As Expected

Copper Contributor

Greetings. I created a pivot table to count the  number of green, yellow and red statuses I have in a column. I have tried dragging the field to rows, columns and values and am only receiving the name of the status color but no numbers. The table is relatively small now and I am using 'countif' formula to get totals for each color but I thought the pivot table would be more efficient. 

 

Please help.

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@NanaNina 

Does it work in the attached file?

well I feel like a lame brain. I didn't know the fields could be dragged to more than one area, Working now. smh. Thanks for the help and the quick response!
1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

@NanaNina 

Does it work in the attached file?

View solution in original post