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:

      333.PNG

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

      444.PNG

      What function should I use?

       

      Thank you very very much!!!