May 15 2023 09:51 AM
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.
May 15 2023 10:00 AM
SolutionDoes it work in the attached file?
May 15 2023 10:14 AM