Percent field with subtotals

09-11-2009, 6:13 AM
Hi,
i need to create this cub:

Value %Value (value/sum(value))
row1 10 20% (100*10/50)
row2 15 30% (100*15/50)
row3 25 25% (100*25/50)
Total 50 100% (100*50/50)

This cub contains a data field calculated using the subtotal of the field.
I tryed with groopfooterexpression or using variable but doesn't work. Any suggestions?

Please help me.
Thanks

Re: Percent field with subtotals

09-13-2009, 11:08 PM

shevro,

Unfortunately, referencing totals in calculated fields is not supported. This is only supported in calculated fields totals. In DynamiCube you can reference the cell where axis fields intersect with data fields by using the data field's VarName as an index.

Thank you,
Andrey T.