pivot table question

[wanyunyang]

I have a pivot table with dimensions: FoodType, Salesrep, SalesArea, Customer, and measure: count(VISIT).

There are only 2 FoodTypes: Apple and Banana. The pivot table is like:

But for the same rep-area-customer, I want count(VISIT) to be the same for Apple and Banana. Should be like:

What function should I use?

Thank you very very much!!!

[wanyunyang]

Thank you!