2 Replies Latest reply on Nov 12, 2015 11:36 AM by IT_User

    Comparing Different Records From the Same Field

    yiningw

      There are two parts to the question.

      If I have 3 sellers, John, Mary and Susie, under the field "sellerID", and I want to have a choice to compare each seller's average sales next to the average sales of all of them combined, how would I go about that?

       

      For example, John sold an average of 5 apples and 3 oranges a day, Mary sold 2 apples and 5 oranges, and Susie sold one each. I want to display on one side of a layout that average of John's sales (5 and 3), and on the other side of the same layout the average of all sales ((5+2+1)/3) and ((3+5+1)/3). In other words, the left hand side would be based on finds, but the right hand side would be static.

       

      Is there also an option for me to choose whether I want to see Mary's average sales compared against all as well as Susie's? I'm aware of the drop down option but I'm not sure how to implement a proper script so that clicking on the records will perform those finds.

       

      Thanks!