Help needed badly! Subfilter on values?

Kind of tricky to explain, but I badly need help with this...it drives me crazy every day. I've attached a file containing dummy numbers to help.

I have a report with a lot of data points, but the ones included are primary. As you can see, there are five order numbers split over 12 lines, so there are multiple lines for one order number.

I need to display all the lines under each order number as one. ie - Merge the values together for that order number. Easy enough manually with the small example I've provided - not with thousands of lines.

The whole point of this exercise is to display all order numbers which have multiple amounts of P1, and 0 P2.

I figured the easiest way to do this would be a pivot. In this case we can see it will applies only to the BA order (2xP1 and 0xP2). However, I need to be able to hide all orders that do NOT meet this criteria. So BA should be the only order left showing in the list.

Basically, I need a way to filter the values in a pivot table in the same way that you can do with an autofilter (number filters P1>1, P2=0)

I'm sure there's a simple fix for this and I'll be eternally grateful to whoever can help me, because this request is driving me round the twist! I'm on Office 2010

Thanks guys!

dummydataimage.PNG

dummydata.xlsx

EDIT:// I tried a slicer, but it is filtering each individual line rather than the TOTAL for that order number. Is it possible to slice by total? I think this might just be what I need to do....