numbers
I can't find any equivalent of the Excel Pivot Table or Open Office Data Table features. I'd like to sum up my data grouped by values in various columns.
For example, if I have
A B C
red left 2
red left 3
green left 4
green right 4
I want to be able to get
red green all
left 5 4 9
right 0 4 4
all 5 8 13
Not sure if anything will ever beat Excel for Windows XP.
But I think Google Spreadsheets are a close second. Zippy enough without all the graphics and sluggishness of Numbers / Excel for Mac.
Then again, it runs in your browser.
HTH.
Thanks to your sample file, I think I was able to do what you wished.
Using an additional column to bring in the numbers corresponding to the codes (16AA, 1; 16AE, 2...) sorting by that column then hiding it the desired result was accomplished. To refresh the sort after adding data, unhide the column and sort again.
Here are the steps:
Create new column to the left of the "Code" column.
Add a formula to extract the proper number for each code and copy down.
Formula: =INDEX (Group::c, MATCH (B, Group::A))
(Using INDEX(MATCH) is a good way to get column data with out worrying about extra columns being added as is the case with VLOOKUP.)
Result:
Best Answer
Assuming the tables are named Original and Pivot, the cells in Pivot are filled using this formula:
i.e. sum values in
Original::$CifOriginal::$A= value in first column of PivotOriginal::$B= value in first row of PivotThe 'all' values are just simple sums of those rows or columns.