Single Tables, Filters and Categories in Mac Numbers

Dividing up your data among multiple tables across different sheets can make it difficult to perform calculations and organize. But by using filters or categories you can easily manage your data in a single table. You can also use Pivot Tables in some cases.

Comments: 6 Responses to “Single Tables, Filters and Categories in Mac Numbers”

    pws442
    2 months ago

    Is there a way to cap a SUM in a Categories Summary? I.E. I can cap an individual row, but would like to cap the category SUM.

    2 months ago

    pws442: do you mean a sum but limited to a maximum value? You canā€™t do that with Categories but you can just do it using regular formulas.

    Paul
    2 months ago

    How do I cap a category summary row value?

    2 months ago

    Paul: What do you mean by "cap?" Do you mean limit it to a maximum value? You can't do that using categories. You'll need to make your own formula that uses MIN and SUM (or whatever the value function is).

    Clint
    2 months ago

    Hey gary,
    I'm using numbers for Icloud and iv'e hit the cap on number of filters. I tried following one of your videos but i cant pull it off. I've gotten as far as functional true/false columns. Can not for the life of me group their use in a single filter. Please help!
    Thanks

    2 months ago

    Clint: Turn off the filters. Forget them for a minute. Now create a new column. Use that column to put a formula in it that includes whatever you want the "filter" to be. So a combination of IF and other things. Your goal is that every column you want to "see" should have a TRUE in it, and every column you want hidden should have a FALSE in it. Once you get that working to your satisfaction, then you an put a filter for TRUE on that one column.

Leave a New Comment Related to "Single Tables, Filters and Categories in Mac Numbers"

:
:
:
0/500 (500 character limit -- please state your comment succinctly and do not try to get around this limit by posting two comments)