How do I create a pivot table in numbers?
How do I create a pivot table in numbers?
MacBook Pro
How do I create a pivot table in numbers?
MacBook Pro
I know that it's an old question but I thought it might help other who are Googling for the answer and end up here. I think you can find the best answer here: https://devinthefastlane.wordpress.com/2017/01/23/how-to-mimic-pivot-table-or-ca tegories-in-number-3/
I know that it's an old question but I thought it might help other who are Googling for the answer and end up here. I think you can find the best answer here: https://devinthefastlane.wordpress.com/2017/01/23/how-to-mimic-pivot-table-or-ca tegories-in-number-3/
There is no equivalent in Numbers to Excel's Pivot Table. It might be helpful for you to view this MacMost tutorial on Numbers' Table Categories feature in which the author talks about the similarities.
http://macmost.com/pivot-tables-in-iwork-09-numbers.html
Jerry
While Categories was a very useful and in many ways superior feature to pivot tables, it has just been stripped from Numbers 3.0. I am not aware of any feature that will replace it. ðŸ˜
SO HERE'S WHAT I GOT TO WORK:
Truth is all the real functionality of categories and pivot tables exists in the formulas. You just have to
While I admit the formulas are not nearly so graphic as categories, they are cleaner and less restricting, and they aren't any more difficult to work with than pivot tables.
this is no where near as powerful as categories or pivot tables.
the reason to not use the formula method is when new data comes in with new "categories" you have to rewrite your list of categories.
if you've got a large data set this is very very time consuming and error prone and messy.
making the unique list isnt time consuming, problimatic, or error prone if you use the existing methods mentioned in many posts for creating unique lists from numbers tables. simple formula and a sort in some of the simpler forms.
Take your new unique list and paste it into a column. Fill your equation down and your done. I have at least one support call a week where someone doesnt understand PTs and they are showing bad results due to range issues. This method takes care of that becuase in numbers is it really easy to refer to the columns by name.
Where in excel it allows many tables to be on one sheet, which can cause issues for beginners.
Jason
+1 It is a very useful and fundamental function to me, without this function I will revert to use excel instead.
I think Number 3.0 is good and good looking UI, but lack of some basic fundamental functions compared with Number 09
Yes, I think the only method to use something like Pivot table or orginal category under Number 09 is using the formula "sumif"
How do I create a pivot table in numbers?