DIMENSION LEVEL MEASURE

[elsietina]

hello all,

i have a table product which has the following values

product
item group


and measure

total sales


i would like to create a new measure in transformer cube that would be the average total sales of item group.

please is this possible if yes how do i do that.

thanks in advance

[goldsmt]

Hi

Add the sales value to the measures and name it total sales, add the sales value again to the measures and call it Averake sales. double click on the measure ann set its rollup properties to average.