I'm new to Numbers and currently using Numbers 3.2.
I already have an idea of how to use SUMIFS to create Pivot Tables in Numbers, but I'm still looking for a better way to generate the column & row names.
For example, if I have:
A B C red left 2 red left 3 green left 4 green right 4
I want to be able to get:
red green all left 5 4 9 right 0 4 4 all 5 8 13
When the dataset is 2x2, I can simply retype the column & row names. But if the dataset is 20x10,000...
I read that they have this category feature in Numbers '09, but how do I implement it in Numbers 3.2?