Mar 14 2021 08:12 AM
Greetings,
I am trying to maximize the utilization of Excel features but admit my knowledge is lacking. I have a pivot table comparing data from two months so I can generate a gain/loss column. Can I do that using a formula with my pivot table?
I was trying to figure out if there is a blank in column A then I want "gain" to be in column D. If column B is blank then "loss" in column D. Hopefully I'm asking the right question. Thanks.
1 | 1 | ||
1 | 1 | 2 | |
1 | 1 | ||
1 | 1 | 2 | |
1 | 1 | ||
1 | 1 | ||
1 | 1 | ||
1 | 1 | ||
1 | 1 | 2 | |
1 | 1 | ||
1 | 1 | ||
1 | 1 | 2 | |
1 | 1 | 2 | |
1 | 1 | 2 | |
1 | 1 | 2 | |
1 | 1 | ||
1 | 1 | 2 | |
1 | 1 | 2 |
Mar 14 2021 08:23 AM
This grid in your post is that part of PivotTable or part of source data? If the latest why do you need PivotTable and on which field you pivot?
It will be much better if you provide small sample file.