Forum Discussion
Pivot Table Not Working As Expected
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.
Does it work in the attached file?
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!
