Average Daily Sales

• Anita Portwood

  SSC Enthusiast

  Points: 128

  More actions

  May 19, 2009 at 5:38 am

  #204387

  I am working with a cube and have my date hierarchy as Year - Quarter - Month - Day. I need to be able to get Average Daily Charges. For example, for January, I need sales/31 days, however, if we're in May on the 19th, I need the charges/current day number. Thanks.

• Samuel Vella

  SSCrazy Eights

  Points: 8055

  More actions

  May 19, 2009 at 8:36 am

  #997037

  You can use the average function

  with member [measures].[month avg] as

  avg({[Time Dimension].[Hierarchy Name].currentmember.siblings}, [measures].[charges measure])