2 Replies Latest reply on Oct 27, 2018 9:06 AM by Ombir Rathee

    fixed formula for average of subcategories by category

    Alex Martino

      I have data that has multiple rows within each category and subcategory.

       

      How can I take the average sale amount PER subcategory within each category.

       

      I tried this but it didn't work {Fixed [Major Expense Head]: AVG([Amount])}

       

      It seems like it gives me the average of each row and I want the average of subcategory total within the category.

       

      For example (sum)

       

      subcat1 =100

      sbucat2 = 400

       

      category average = 250