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