I am suppressing certain transactions based on the following criteria:
Material View (works fine)
Price 2011: only show Material Price for 2011 if Material has Price in 2011 and 2012
Price 2012: only show Material Price for 2012 if Material has Price in 2011 and 2012
Quantity 2011 only show Material Quantity for 2011 if Material has Price in 2011 and 2012
Quantity 2012 only show Material Quantity for 2012 if Material has Price in 2011 and 2012
Customer View (this is where the problem is)
Price 2011: only show Material Price for 2011 if Customer has purchased the same Material has Price in 2011 and 2012
Price 2012: only show Material Price for 2012 if Customer has purchased the same Material has Price in 2011 and 2012
Quantity 2011 only show Material Quantity for 2011 if Customer has purchased the same Material has Price in 2011 and 2012
Quantity 2012 only show Material Quantity for 2012 if Customer has purchased the same Material has Price in 2011 and 2012
Therefore the aggregation in the customer view should be based on customer and material, as it only makes sense to compare customers who have purchased the same material in both years.
This works well if you look at my example in step 1 for Price only.
However, I am having difficulties to apply the correct formula when in the customer view for quantities, while trying to check if there is a Price.
I have attached all the detailed steps to clarify what I really need and where my problem starts.
