Pivot tables
HI is there pivot tables in numbers app
MacBook Pro with Retina display, OS X Yosemite (10.10.3)
3 replies
You can make summary tables (the most common use of Pivot tables), using existing SUMIF and COUNTIF functions.
If you are married to using Pivot tables themselves then you must use a different product. If you dont mind writting a formula, you can make the equivalent by hand in Numbers.
Search in this forum for old posts on how to do so.
Jason
To my knowledge, there is NO spreadsheet app for iOS that allows for the creation of pivot table (Excel for iOS presumably will allow for reading pivot table, but frankly doesn't do a very good job of it). As suggest, you might be able to "fake" one using formulas, but compared to pivot tables in Excel for a desktop, it will be rather limited.
Pivot tables