Numbers User Guide for iPhone
- Welcome
- What’s new in Numbers 14.1
-
- Get started with Numbers
- Intro to images, charts, and other objects
- Create a spreadsheet
- Open spreadsheets
- Prevent accidental editing
- Personalize templates
- Use sheets
- Undo or redo changes
- Save your spreadsheet
- Find a spreadsheet
- Delete a spreadsheet
- Print a spreadsheet
- Change the sheet background
- Copy text and objects between apps
- Touchscreen basics
- Copyright
![](https://help.apple.com/assets/65E6150B6FF3556065071CF8/65E6150C60D78F13600351D8/en_US/61e57fb81071150c7da08e52bb0d3db6.png)
View the source data for a value in a pivot table in Numbers on iPhone
You can create a table of the source data that corresponds with any populated cell in a pivot table. This is especially useful if you are analyzing data in a pivot table and want to better understand how a particular value was calculated, without having to look through a large source table. For example, if you have a pivot table tracking student performance and one student’s average grade seems lower than expected, you can create a table of source data for all their scores to see if one was entered incorrectly.
Select a populated cell in a pivot table.
Tap
, then tap Create Table for Source Data.
A new table is added on the same sheet as the selected cell. It displays the column headings and values in the original source table that are used to calculate the value in the cell you selected.