One way to do this is to create a calculated field similar to the following:
if sum([ProductHitCount])=0 and max(Year)=2011 then 1
elseif sum([ProductHitCount])>0 and max(Year)=2012 then 1
Then, place this calculation on the filter shelf, and filter to 1.
Hope this helps!
That worked. Thanks Tracy!
What if there was no related row. For example AXDVD has an entry for 2012 but not for 2011
Need to display only Customer that had Zero (0) ProductHitCount in 2011 or no entry and have ProductHitCount greater than 0 in 2012.