diogodasilva

Q: Group Rows into Categories gone in new Numbers

Can't believe Apple ditched Group Rows into Categories just to make it compatible across web and iOS?

Am I going crazy or what?

 

This is how it used to be: http://support.apple.com/kb/VI139

MacBook Pro, Mac OS X (10.7.4)

Posted on Oct 23, 2013 5:39 AM

Close

Q: Group Rows into Categories gone in new Numbers

  • All replies
  • Helpful answers

Page 1 Next
  • by Jerrold Green1,

    Jerrold Green1 Jerrold Green1 Oct 23, 2013 6:00 AM in response to diogodasilva
    Level 7 (29,996 points)
    Oct 23, 2013 6:00 AM in response to diogodasilva

    Use the Feedback tool in the Numbers menu.

     

    I'm keeping a list if stuff that's "gone missing". Just added Category View to my list.

     

    Jerry

  • by Veluto,

    Veluto Veluto Jun 2, 2014 9:56 AM in response to Jerrold Green1
    Level 1 (0 points)
    Jun 2, 2014 9:56 AM in response to Jerrold Green1

    I can believe it either that this feature is gone!!! It was the reason I liked more Numbers than Excell!

     

    I hope it comes bak soon!!!

  • by SGIII,

    SGIII SGIII Jun 2, 2014 10:39 AM in response to Veluto
    Level 6 (10,627 points)
    Mac OS X
    Jun 2, 2014 10:39 AM in response to Veluto

    the reason I liked more Numbers than Excell!

     

    Actually I like Excel's pivot tables more than the old Categories, RIP.

     

    Have you considered using SUMIFS and COUNTIFS?

     

    SUMIFS.png

     

     

    The big advantage to this formula-based approach (over both the old Numbers's Categories and Excel's Pivot Tables) is that the results are easily used for ongoing calculations or for making charts.

     

    SG

  • by sjlawton,

    sjlawton sjlawton Oct 19, 2014 1:54 AM in response to Jerrold Green1
    Level 1 (4 points)
    Oct 19, 2014 1:54 AM in response to Jerrold Green1

    I'm keeping a list if stuff that's "gone missing". Just added Category View to my list.

     

    Jerry

     

    ______________________________

     

    Jerry,

     

    I know that this post was a year ago, but do you still maintain that list of Numbers 2.3 features that are missing in Numbers 3? I would be very interested to read it.

     

    Thanks,

     

    Simon.

  • by SGIII,

    SGIII SGIII Oct 19, 2014 8:24 AM in response to sjlawton
    Level 6 (10,627 points)
    Mac OS X
    Oct 19, 2014 8:24 AM in response to sjlawton

    Simon,

     

    Keeping a "missing" list is less satisfying now because it's so much shorter than it was back then.  Categories (the subject of this thread) is still on it.  So is ease of seeing how document will look in print. Also some niche things such as import of OFX files (from financial institutions).

     

    Meanwhile, the "new" features list continues to grow: dramatically better cross-platform sync, much improved AppleScript support, easier Pop-Up Menu, improved Conditional Highlighting (Formatting), Interactive Charts, Transpose Rows and Columns.

     

    SG

  • by sjlawton,

    sjlawton sjlawton Oct 19, 2014 9:47 AM in response to SGIII
    Level 1 (4 points)
    Oct 19, 2014 9:47 AM in response to SGIII

    Thanks for that. One of my spreadsheets does make use of Categories so I would miss that.

     

    I have another spreadsheet that makes extensive use of some complicated nested functions. In Numbers 2.3 I can edit the function at the top of the screen and expand that area to see the formula in its entirety. I'm a little worried that Numbers 3.5 doesn't easily cope with editing large formulas. Here is an example of one such formula:

     

    =(VLOOKUP(B3,HL Holdings,MATCH(-1,HL Holdings :: $1:$1,0),FALSE)-VLOOKUP(B3,HL Holdings,MATCH(-5,HL Holdings :: $1:$1,0),FALSE))/VLOOKUP(B3,HL Holdings,MATCH(-5,HL Holdings :: $1:$1,0),FALSE)

     

    Do you have a view on how well Numbers 3.5 manages entering/editing of such lengthy nested functions?

     

    Thanks,

     

    Simon.

  • by SGIII,

    SGIII SGIII Oct 19, 2014 10:14 AM in response to sjlawton
    Level 6 (10,627 points)
    Mac OS X
    Oct 19, 2014 10:14 AM in response to sjlawton

    Here's a screenshot of the formula editor in Numbers 3.5:

     

    Screen Shot 2014-10-19 at 1.10.10 PM.png

     

    As you can see, plenty of room (it can go much bigger than this).

     

    You just have to know that from its default size (smaller than shown here) you can pull it as wide and tall as you want by dragging on the edges.

     

    SG

  • by sjlawton,

    sjlawton sjlawton Oct 19, 2014 10:18 AM in response to SGIII
    Level 1 (4 points)
    Oct 19, 2014 10:18 AM in response to SGIII

    Thanks SG - unfortunately, all I can see is a white question mark in a little blue box.

     

    For some reason the screenshot is not showing for me. Is is something I'm doing wrong?

  • by SGIII,

    SGIII SGIII Oct 19, 2014 10:26 AM in response to sjlawton
    Level 6 (10,627 points)
    Mac OS X
    Oct 19, 2014 10:26 AM in response to sjlawton

    No that's a problem with the forum. Very irritating. Sometimes double-clicking the blue box helps to see the image, and sometimes it doesn't.

     

    The image was of your formula above as it looks the Numbers 3.5 formula editor, which I had dragged large so formula occupied only about a third of the space (which could be made larger still, just by further dragging on the edges). 

     

    Once you learn how to resize the editor you won't have any problem handling very, very, very long formulas.

     

    SG

  • by sjlawton,

    sjlawton sjlawton Oct 19, 2014 10:32 AM in response to SGIII
    Level 1 (4 points)
    Oct 19, 2014 10:32 AM in response to SGIII

    Thanks SG. That's reassuring.

     

    Still can't see the screenshot - pity I'm quite curious to see what it looks like.

     

    Thanks again,

     

    Simon.

  • by oinkbaamoo,

    oinkbaamoo oinkbaamoo Jan 9, 2015 6:06 AM in response to diogodasilva
    Level 1 (0 points)
    Jan 9, 2015 6:06 AM in response to diogodasilva

    Can anyone help me: I have a master table of data:

    Date

    month

    Company

    category

    description

    amount

    7 January

    1

    Coop Nära

    week shop

     

    SEK 298

    7 January

    1

    Take Off

    luxury

    coffee

    SEK 68

    I want to be able to create tables from this which can sort by "month" and "category", like an excel pivot table (i.e. updates automatically after I enter data in the master table, giving me 12 separate tables (Jan to Dec) each sorted by category.)

  • by Jerrold Green1,

    Jerrold Green1 Jerrold Green1 Jan 9, 2015 6:53 AM in response to oinkbaamoo
    Level 7 (29,996 points)
    Jan 9, 2015 6:53 AM in response to oinkbaamoo

    OBM,

     

    Please post this question as a new discussion.

     

    Jerry

  • by SGIII,

    SGIII SGIII Jan 9, 2015 9:06 AM in response to oinkbaamoo
    Level 6 (10,627 points)
    Mac OS X
    Jan 9, 2015 9:06 AM in response to oinkbaamoo

    And see the example using SUMIFS above.  You would set up 12 separate summary tables.  Each of these will update automatically when you make changes in the master table.  (BTW, I do not believe Excel pivot tables update automatically; after making changes in the source data, the user has to "Refresh".)

  • by oinkbaamoo,

    oinkbaamoo oinkbaamoo Jan 9, 2015 10:12 AM in response to SGIII
    Level 1 (0 points)
    Jan 9, 2015 10:12 AM in response to SGIII

    Sorry for repeating a question Jerry.

     

    SG, the SUMIFS seems to work a treat. I bow to your genius! Thanks a lot.

     

    David

Page 1 Next