Want to highlight a helpful answer? Upvote!
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
I have been using Numbers more and more.
I came across the need to create a new pivot table and want to do it in Numbers 3.5
I saw a video on how to do this in Numbers '09 but also saw reports that this feature was removed from the Numbers application recently.
Question - Is there an easy way to create a summary/filterable sheet from the data that I have?
TIA - JP
OS X Yosemite (10.10)
Hi James,
If I have understood correctly, you are looking for Categories. Sadly, they have gone in Numbers 3.
Numbers '09 allows this:
Produced by the Reorganise Panel:
Sorry, that feature has gone in Numbers 3.
In Numbers 3, here is a data table:
Create your own subtotals in Footer Rows (or in another table)
Formula in Footer Cell B6 (and Fill Down to Footer Cell B7)
=SUMIF(A,A6,B)
Or use a Filter to show only rows that match a condition:
To see this:
Please reply if I have misunderstood your aim.
Regards,
Ian,
Hi James,
If I have understood correctly, you are looking for Categories. Sadly, they have gone in Numbers 3.
Numbers '09 allows this:
Produced by the Reorganise Panel:
Sorry, that feature has gone in Numbers 3.
In Numbers 3, here is a data table:
Create your own subtotals in Footer Rows (or in another table)
Formula in Footer Cell B6 (and Fill Down to Footer Cell B7)
=SUMIF(A,A6,B)
Or use a Filter to show only rows that match a condition:
To see this:
Please reply if I have misunderstood your aim.
Regards,
Ian,
Thanks.
I guess that I might need more "education".
Can you recommend a good set of video tutorials for Numbers 3.5 that would cover more advanced features?
Jim P.
Hi Jim,
Thanks for your reply. Seriously, Numbers 3.5 is not so different from Numbers '09. But often we need to "take a walk around the new neighbourhood" to see where the old features have been moved (not always removed 🙂). Where have they hidden that in this update? What do I need to do to adapt to this 'new look' Numbers?
Question - Is there an easy way to create a summary/filterable sheet from the data that I have?
Please place screen shot of your data to give an idea of your aim. Remove or hide sensitive details.
Please reply with a screen shot of a small part of your screen (large shots are often difficult to read).
Wayne Contello has written a User Tip on how to post a screen shot.
https://discussions.apple.com/docs/DOC-6591
Regards,
Ian.
I created a list and a pivot table in Excel and took a snapshot of them.
I'd like to filter by "Month", List by Category and Name, summing amounts within Category.
Does this help?
Hi Jim,
I can't see an easy way of creating a "Pivot Table" in Numbers 3 unless it involves some SUMIF or SUMIFS functions in formulas.
The only way I can see is to revert your Numbers 3 document to Numbers '09 and use the Numbers '09 Categories feature.
In Numbers 3, Menu > File > Export To > Numbers '09...
Here's hoping that you have Numbers '09 on your machine 🙂.
Regards,
Ian.
Unfortunately, I don't have a machine with Numbers '09.
Sad that such a nice feature was dropped.
Thanks for your input.
Would SGIII's response in his June 2014 post response add clarity to forming Pivot tables in Numbers v3.5?
How do I create a "pivot table" in numbers 3.5?
