Hi Excel Forum,
I need some Excel Pivot Table help, I'm not quite sure how to express this question in technically appropriate excel vernacular so I've created an illustration.
Considering the attached example, is there an elegant way to use one pivot table to count (not sum) the number of times each seeded food type ('food_seeded') occurs for every "unique food_sub_class" and express the count as an expression of "food_class" by "food seeded"?
Thank-you!
Bookmarks