Changing sum to average

• Usman Tanveer-239283

  Ten Centuries

  Points: 1104

  More actions

  February 21, 2006 at 4:24 am

  #189350

  Is it possible to show the "average value" as a defualt behavior of a measure, currently it is the "Sum value".

  To-eloborate.......

  when a measure is added in the Data View Area it shows the sum of all available values, i want to change this behavior so that instead of sum average of all the available values is shown.

• Bad dog

  Old Hand

  Points: 387

  More actions

  February 21, 2006 at 11:54 pm

  #622526

  You could do a calculated measure that divides e.g. Sales Price by units to get an average sales price. Something like:

  [Measures].[Store Sales]/[Measures].[Sales Count]

  Not sure what you are averaging but this should work for most scenarios.

  There is also a function: Avg() that you can use in a calculated measure. This requires a set and has an optional numeric value parameter

   

  Hope this helps