1 Reply Latest reply: Dec 11, 2012 9:29 AM by jaxjason
Nardo10s Level 1 Level 1 (0 points)

can you create pivot tables on numbers the same way you can with excel?

  • 1. Re: can numbers perform pivot tables
    jaxjason Level 4 Level 4 (3,335 points)

    No no pivot tables in numbers.... however...


    Pivot tables are generally a fast method of using functions already existing to perform summarization, therefore even though they do not exist as an automatic function in numbers, you can use the basic CountIF, SumIF, etc... functions in a table you make to perform the same functionality. This has been done by many of us over the years and it works fairly well. You lose some of the "pivot" ability and no drag and drop. so it takes a little more planning beforehand.


    Jason Kent