Discussion Pivot tables and IF formula in Excel
https://techcommunity.microsoft.com/t5/excel/pivot-tables-and-if-formula/m-p/2208990#M92817
<P>Greetings,</P><P> </P><P>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? </P><P> </P><P>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.</P><TABLE width="302"><TBODY><TR><TD>1</TD><TD> </TD><TD>1</TD><TD> </TD></TR><TR><TD>1</TD><TD>1</TD><TD>2</TD><TD> </TD></TR><TR><TD>1</TD><TD> </TD><TD>1</TD><TD> </TD></TR><TR><TD>1</TD><TD>1</TD><TD>2</TD><TD> </TD></TR><TR><TD>1</TD><TD> </TD><TD>1</TD><TD> </TD></TR><TR><TD>1</TD><TD> </TD><TD>1</TD><TD> </TD></TR><TR><TD>1</TD><TD> </TD><TD>1</TD><TD> </TD></TR><TR><TD>1</TD><TD> </TD><TD>1</TD><TD> </TD></TR><TR><TD>1</TD><TD>1</TD><TD>2</TD><TD> </TD></TR><TR><TD>1</TD><TD> </TD><TD>1</TD><TD> </TD></TR><TR><TD>1</TD><TD> </TD><TD>1</TD><TD> </TD></TR><TR><TD>1</TD><TD>1</TD><TD>2</TD><TD> </TD></TR><TR><TD>1</TD><TD>1</TD><TD>2</TD><TD> </TD></TR><TR><TD>1</TD><TD>1</TD><TD>2</TD><TD> </TD></TR><TR><TD>1</TD><TD>1</TD><TD>2</TD><TD> </TD></TR><TR><TD>1</TD><TD> </TD><TD>1</TD><TD> </TD></TR><TR><TD>1</TD><TD>1</TD><TD>2</TD><TD> </TD></TR><TR><TD>1</TD><TD>1</TD><TD>2</TD><TD> </TD></TR></TBODY></TABLE>Sun, 14 Mar 2021 15:12:51 GMTholubyrx2021-03-14T15:12:51ZPivot tables and IF formula
https://techcommunity.microsoft.com/t5/excel/pivot-tables-and-if-formula/m-p/2208990#M92817
<P>Greetings,</P><P> </P><P>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? </P><P> </P><P>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.</P><TABLE width="302"><TBODY><TR><TD>1</TD><TD> </TD><TD>1</TD><TD> </TD></TR><TR><TD>1</TD><TD>1</TD><TD>2</TD><TD> </TD></TR><TR><TD>1</TD><TD> </TD><TD>1</TD><TD> </TD></TR><TR><TD>1</TD><TD>1</TD><TD>2</TD><TD> </TD></TR><TR><TD>1</TD><TD> </TD><TD>1</TD><TD> </TD></TR><TR><TD>1</TD><TD> </TD><TD>1</TD><TD> </TD></TR><TR><TD>1</TD><TD> </TD><TD>1</TD><TD> </TD></TR><TR><TD>1</TD><TD> </TD><TD>1</TD><TD> </TD></TR><TR><TD>1</TD><TD>1</TD><TD>2</TD><TD> </TD></TR><TR><TD>1</TD><TD> </TD><TD>1</TD><TD> </TD></TR><TR><TD>1</TD><TD> </TD><TD>1</TD><TD> </TD></TR><TR><TD>1</TD><TD>1</TD><TD>2</TD><TD> </TD></TR><TR><TD>1</TD><TD>1</TD><TD>2</TD><TD> </TD></TR><TR><TD>1</TD><TD>1</TD><TD>2</TD><TD> </TD></TR><TR><TD>1</TD><TD>1</TD><TD>2</TD><TD> </TD></TR><TR><TD>1</TD><TD> </TD><TD>1</TD><TD> </TD></TR><TR><TD>1</TD><TD>1</TD><TD>2</TD><TD> </TD></TR><TR><TD>1</TD><TD>1</TD><TD>2</TD><TD> </TD></TR></TBODY></TABLE>Sun, 14 Mar 2021 15:12:51 GMThttps://techcommunity.microsoft.com/t5/excel/pivot-tables-and-if-formula/m-p/2208990#M92817holubyrx2021-03-14T15:12:51ZRe: Pivot tables and IF formula
https://techcommunity.microsoft.com/t5/excel/pivot-tables-and-if-formula/m-p/2209005#M92821
<P><LI-USER uid="996868"></LI-USER> </P>
<P>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? </P>
<P>It will be much better if you provide small sample file.</P>Sun, 14 Mar 2021 15:23:14 GMThttps://techcommunity.microsoft.com/t5/excel/pivot-tables-and-if-formula/m-p/2209005#M92821Sergei Baklan2021-03-14T15:23:14Z