2 Replies Latest reply on Aug 27, 2017 4:17 PM by Sara Alsughaiyer

    How to calculate average sales for a specific category in a parameter?

    Sara Alsughaiyer

      Hello All,

       

      I really need some with one of my charts. My dataset is about houses sold in a period of one year. I am trying to create a chart with a parameter for the number of bedrooms, once I choose a number ( let's say 4 bedrooms) I would like my chart to view monthly average sales for all the houses sold with four bedrooms only. I tried creating a calculated field but still struggling as to how to create the calculation! Attached is my packaged workbook with data set included. The sheet I was working on is called "Monthly Avg Bedrooms".

       

      Thanks in advance!

      Sara