Forum Discussion
How to add a conditional formula to a Pivot?
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 i...
See if attached file does what you expect...
as I have a hard time to figure out a couple of things (might be me 🙂 - it's quite late my time)
Hello Lorenzo
First, thank you for your help, and I apologize for the delayed reply. In your scenario, is there a way to create a filter for items that have purchase and negative adjustment values only?
Basically, what I need to know is which products were purchased this month and also adjusted this month.