Previous 1 2 Next 17 Replies Latest reply: Feb 11, 2008 1:15 PM by WWJD
Tommy Boothe Level 2 (165 points)
Does anyone know if Numbers will do pivot tables?

MacBook Pro, Mac OS X (10.4.10)
  • Play'nW/Numbers Level 1 (10 points)
    Pivot tables aren't supported & are converted to regular tables.
  • Play'nW/Numbers Level 1 (10 points)
    Argh ,sorry, having problems finishing my post!

    Thats the message I see when I import a Pivot Table, I couldn't find a way to create them natively, so it looks like they don't support them=(

    Maybe next release!? One can hope!

    Lov'n the trial!
  • anon000 Level 1 (0 points)
    The Pivot Table is one of the most useful, versatile, and simple tools in Excel. I am astonished that Apple would not include it in Numbers.

    It's a shame, I was hoping to ditch Excel for Numbers. Not yet, it seems...
  • Tommy Boothe Level 2 (165 points)
    I agree. Without the pivot table functionality, Numbers is not nearly as appealing.
  • Canfile Level 1 (5 points)
    Agreed ! Anyone who has to deal with large lists that need to be summarized, is left hi and dry without an equivalent to the Pivot Table tool in Numbers. For my part, I'm not buying iWorks '08 untill there's an update available with that function. Let's just hope it comes out before Microsoft releases their updated Office suite...
  • Boston Joe Level 1 (35 points)
    I'm not just astonished, I'm shocked, flabbergasted, and apoplectic that Pivot Table functionality wasn't included. I mean even Neooffice has this! How hard can this be?

    It was with a great deal of reluctance that I bought Office when I got my Mac 2 yrs. ago. I've been waiting for the spreadsheet so that I can dump Office, and now this. How disappointing!
  • Boston Joe Level 1 (35 points)
    Oh, and don't take my word for it.

    Here's what Walt Mossberg said in today's WSJ: "For real spreadsheet jockeys, however, Numbers is wimpier than Excel. It has only about half as many functions for making calculations and doesn't do pivot tables."

    Ouch! The wimp factor. That's the handle that drove "41" up the wall.
  • Howard Solomon Level 1 (20 points)
    Try using the sumif function. It works easily by selecting the row or column to do the lookup from and is very easy to setup if you aren't a pivot table expert.
  • ShatterdRose Level 1 (10 points)
    Yeah, but have you been able to do it natively on a date range? I'm trying to do it based on Months but in order to do it I have to create a hidden column and extract the month into it. Not as elegant as I would hope . . .
  • SzimiStyle Level 1 (0 points)
    If Pivot Table-like function would be included in the next upgrade I would immediately back to use it. Now it is just waste of time. And the help is just for nothing. Disappointed!
  • Level 8 (41,790 points)

    You wrote:
    +And the help is just for nothing+

    I'm quite sure that you are using the english version on a system whose decimal separator is the comma.

    Apple wrote the english version with the point as decimal separator.
    So in the english product, the operands separator is the comma while it is the semi-colon with our decimal comma.

    As I already wrote, I will ask Apple for a revised version adjusting the delimiter used in the "Insert functions" tool but I'm not sure that it wold be doable for the Help.

    Maybe the easier track would be to deliver an english-with-semicolons version.

    Yvan KOENIG (from FRANCE samedi 15 septembre 2007 08:52:31)
  • jaxjason Level 4 (3,535 points)
    people, search on pivot tables. If you really are a power user of spreadsheets, you should be able to recreate the similar functionality of a pivot table without the overhead of a background DB file that Excel creates. (Ever notice you have to refresh the table every time the data changes? Its using a Jet DB engine, same as Access to handle it I believe.)

    Also, this is the "Spreadsheet for the rest of us." As Mr. Jobs put it in his Keynote. The "rest of us", don't use Pivot tables.

    Oh, and yes, I already posted a way of doing this in the groups here, search around and I believe you can find it.

    Sorry if it comes across wrong, but I think many many people are sooo wanting to abandon MS that they are upset that the version 1.0 of a brand new product isn't beating the pants off a program with over twenty years of development. Kinda losing their point of view on this one people are..

  • BioRich Level 1 (65 points)
    I agree. I too wish to abandon Excel, but for the tougher stuff, we have to use it.

    Just make sure we get the message to Apple that this indeed deserves the attention it needs to bring it into a very useful product. I'm sure people would love to see this thing grow into something very serious.

    For a v1.0, it's pretty remarkable.
  • mac@bcn Level 1 (0 points)
    I agree with you... if Apple really wants us to forget about Office, they should implement:

    * powerful pivot tables (from Excel files and OLAP cubes)

    * macro capability

    * database connection

    * speed

    For the rest, Numbers is a new spreadcheet concept that we should be able to learn easily, and presentation is years ahead of MS Office
Previous 1 2 Next