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