6 Replies Latest reply on Oct 29, 2011 6:09 AM by Michelle Lund

    Creating a calculated field that creates an aggregate for each subcategory?

    Michelle Lund

      Hi guys - I appreciate all the great support that you offer!

       

      I am trying to create a calculated field that aggregates values (e.g average sales) by subcategory (e.g. East, West etc).  It would be one thing if I only had a few subcategories, because then I imagine that you could write something like "If subcategory=East THEN  AVG(sales)  for each subcategory type.  However, I have hundreds of subcategories so I can't write a separate IF or CASE line for each subcategory. 

       

      So I am stumped as to how to do this calculation?