10 Replies Latest reply: Jul 20, 2018 1:45 PM by Wanyun Yang RSS

    pivot table question

    Wanyun Yang

      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!!!