Show Raw Data From PivotTable

0

1

In Excel, I have a PivotTable. I'd like to see all of the cells that went into individual calculation. For instance, if I would like to see all the individual values that made up B@ (Mark/Profit) in the PivotTable below, and have them displayed as a column, how would I do that?

|      | Profit | Loss |
|------|--------|------|
| Mark | 5      | 10   |
| John | 7      | 8    |

Adam_G

Posted 2015-03-10T03:53:36.643

Reputation: 162

Answers

1

To see all cells that went into the calculation, double-click the cell that holds the value.

A new sheet will open that shows the rows that were used.

Check documentation

RouteXL

Posted 2015-03-10T03:53:36.643

Reputation: 56

Wow! I had no idea that existed. Is there any way to get just the column that's being used? In addition, can I get this for multiple cells in separate columns? – Adam_G – 2015-03-10T11:23:47.090

Asked: 2015-03-10T03:53:36.643

Viewed: 4 546 times

Active: 2015-03-10T16:30:35.210