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?

You must log in to answer this question.

Browse other questions tagged .