Numbers User Guide for iPad
- Welcome
- What’s new in Numbers 14.1
-
- Get started with Numbers
- Intro to images, graphs and other objects
- Create a spreadsheet
- Open spreadsheets
- Prevent accidental editing
- Personalise 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
- Customise the toolbar
- Touchscreen basics
- Use Apple Pencil with Numbers
- Copyright
![](https://help.apple.com/assets/65E6150B6FF3556065071CF8/65E6150D60D78F13600351DE/en_AU/61e57fb81071150c7da08e52bb0d3db6.png)
View the source data for a value in a pivot table in Numbers on iPad
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 analysing 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.