This content has been marked as final. Show 3 replies
I'm trying to compare the qty sold of items, but I only want to see on my Pivot Table the items that repeat in both 2016 and 2017, how should I do it?
So in the example below, I want to see only item 553, since it sold both in 2016 and 2017 while 554 only sold in 2016.
I'm currently using 2 expressions like this:
I tried using AND as in Sum(If(Year='2016' AND SUM(IF(Year='2017',QTY) ) <> 0, QTY)), but it didn't work. Any idea?