how to make

Hi, all

I don't know if I explain what I want to do well.

Anyway, what I want to do is count how many items the customer has for each combination like Ex1).
And also like Ex2), I want to count how many apples(or banana...) there are among the combinations,

so I hope the results come out as follows EX2) when I apply a filter.
Let me know if this is possible.

Thanks