Hello all,

I have a Pivot Table where I track my inventory purchases and negative adjustments during the month. I need to see the results only when there is a purchase, so if the Purchase field is blank, it should not be shown. Is there a way to do this? What I’ve been doing is copying and pasting and using formulas. However, this is not practical because ideally, I would like to view the information directly from the Pivot Table.

Thanks in advance.

​Hello all, I have a Pivot Table where I track my inventory purchases and negative adjustments during the month. I need to see the results only when there is a purchase, so if the Purchase field is blank, it should not be shown. Is there a way to do this? What I’ve been doing is copying and pasting and using formulas. However, this is not practical because ideally, I would like to view the information directly from the Pivot Table.  Thanks in advance.  Read More

​