10 Replies Latest reply on Apr 30, 2018 2:26 PM by Douglas Brockbank

    Creating Dual Lines and Dual Axis Comparing AVG(Sales) for ALL Categories vs SUM(Sales) ONE Category

    Douglas Brockbank

      See attached file

       

      How do I change the first calculation of AVG(Sales(All Categories)) so that it shows one average line and not 3 average lines (one for each category)? That one line should be the average of the sum of Furniture, Technology and Office Supplies.

       

      Once I do that, then I can create a Dual Axis to compare the Sum of the one Categories against the Average of all the Categories.