2 Replies Latest reply on Feb 10, 2013 2:09 PM by Andrew Watson

    Avg of specific region vs avg of all region

    Edwin Fung

      I'm trying to do a average of a specific region vs avg of all regions under a dual chart / bar chart with the capability to pick the region as a filter. So when the filter update, the avg of the region update while the avg of all regions remain static. I have attached a sample data from excel. So say if i pick the West region, the avg sales would be 50 in Jan, 200 in Feb while the all regions avg would be 75 in Jan and 350 in Feb.

       

      I'm thinking using an calculated field like IF ATTR(Region) .... THEN AVG XXX but then I can't update with the filter. I could be on the wrong track. 

       

       

      DateRegionSales
      1/1/2013West50
      1/3/2013West50
      1/15/2013West50
      1/3/2013East100
      1/8/2013East100
      1/10/2013East100
      2/1/2013West200
      2/2/2013West200
      2/4/2013West200
      2/8/2013East500
      2/11/2013East500
      2/21/2013East500