Apple Event: May 7th at 7 am PT

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

I can't seta a column to categorize, its not in my pull down list.I recently upgraded to el

I have fallen back to a previous version of numbers.

In the version that came with El capitan I can not set a category, it does not appear in y column pull down list...

Help?

Numbers-OTHER, OS X El Capitan (10.11.1)

Posted on Nov 27, 2015 6:30 AM

Reply
5 replies

Nov 27, 2015 5:11 PM in response to SGIII

Thanks for the reply... much appreciated.

I was reporting expensive using a chart of accounts I created.

I had a column defined for the amount and another as to the type of expense.

i would then categorize the type column and get subtotals for each type of expense.


My spread sheet was functioning as a set of books for my small business.

I used column categories to generate many reports such as sales, accounts receivable expenses fixed assets and so on.


My UMBERS 3 column tab has no category insertion option listed in the pulldown list. The numbers 3 help text says it should be there but it is not.


I have fallen back to numbers 2 and will continue to use it I guess.


I Just think the roll out of el capitan was poor or premature

It blew away my printer software for both my printers (hp and canon) and this new numbers has now added to the frustration..

Any road, thanks again for the reply and I guess I will be checking the updates for fix.

Nov 28, 2015 5:44 AM in response to jrg1450

Sorry to hear you have been having trouble. My guess is that your printer problems mean you need to download printer drivers updated for El Cap (OS X 10.11.x). Your Numbers problems sound completely separate from that. Numbers hasn't had the the Category feature for years now. The old version you have been using is well over six years old; it is "orphanware" in that it is no longer being developed and there may come a day when you have difficulty running it.


If you wish to post more specifics on how you have been using Category, it's quite possible someone here can show you how to accomplish the same thing in Numbers 3 that is more "future proof."


SG

Nov 28, 2015 2:22 AM in response to jrg1450

Hi jrg,


SGIII wrote:

it's quite possible someone here can show you how to accomplish the same thing in Numbers 3 that is more "future proof."

SG is being far too modest. It was SG who weaned me off categories very soon after the release of Numbers 3.0 and I haven't looked back.

SUMIF and COUNTIF methods to replace the missing categories feature are here:

Re: Group Rows into Categories gone in new Numbers


Regards,

Ian.


P.S. I agree that Numbers '09 is orphanware. Nice to have, but one day it will no longer work. Already, the Share by Email feature is broken. My preferred version is Numbers 3 with a cleaner interface and a context-sensitive "Inspector" (Format Panel).

Ian.

I can't seta a column to categorize, its not in my pull down list.I recently upgraded to el

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.