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 |
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