9 Replies Latest reply on Oct 16, 2013 11:52 AM by Ben Neville

    Avg Amount Spend per Day per Employee per Category.

    Jean Francois Carton


      Hello,

       

      I have to calculate and average $ spend per employee per day for each category.

      I would like to calculate that in a measure item in order to use it in a bullet graph, set a goal and see globaly if I am under the goal or above. (for the company and each employees)

       

      Do you have any idea how to proceed, knowing that I have for one day, multiples rows for each category.

       

      14th March     Paul     Meal     $70

      14th March     Paul     Travel    $150

      15th March     John     Meal     $80

      16th March     Greg     Meal     $50

      16th March     Paul     Meal     $70

      16th March     Paul     Car       $50

       

      Thank you!