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
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.