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.

  1. Go to the Numbers app on your iPad.

  2. Open a spreadsheet, then select a populated cell in a pivot table.

  3. Tap the Cell Action button, 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.

See alsoIntro to pivot tables in Numbers on iPadCreate a pivot table in Numbers on iPadAdd and arrange pivot table data in Numbers on iPadChange how pivot table data is sorted, grouped and more in Numbers on iPadCreate a snapshot of a table in Numbers on iPadFilter data in Numbers on iPadSelect cells in a pivot table to create a pivot chart
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
কাজে লেগেছে?
অক্ষর সীমা: 250
সর্বাধিক অক্ষর সীমা 250।
আপনার মতামতের জন্য ধন্যবাদ।
Morty Proxy This is a proxified and sanitized view of the page, visit original site.