Rollup in the cube

[nanzmercado]

Hi,
is it possible to have a rollup in Average value?

ex.

Month   Inventory at Cost   
1   100   
2   150   
3   100   
4   600   
5   500   
Total (Sum)   1450   
      
Average   1450/5 =    290

Instead of giving 1450 in the Rollup value it will give 290 as average.

Thank YOu

[nmcdermaid]

This is called an 'After Rollup' aggregation.

If you have one measure representing the month count, and one measure representing Inventory, then create a calculated measure and it will automaticalyl do this.

The difficult part is getting the measure representing the month count. You might want to try creating a category count measure and see if that works.