Now I want to create a pivot table that has the dimension OLD/NEW and then I want to sepperate my cosumters in VIP, Regular ...., and then I want to count all my VIP costumers. A VIP costumer is someone who hast more than 4 BUYS and more than 500 SALES.
My Pivot table should look like:
OLD 0 2
NEW 1 1
so basicly what I'm trying to do is to say I have 0 OLD VIP costumers , 2 OLD REGULAR costumers, 1 NEW VIP costumer and 1 NEW REGULAR costumer.