DynamiCube Support

Started by shevro at 09-11-2009 6:13 AM. Topic has 1 replies.

Print Search Rate
Sort Posts:    
   09-11-2009, 6:13 AM
shevro is not online. Last active: 9/14/2009 2:38:29 PM shevro

Not Ranked
Joined on 10-29-2008
Posts 10
Percent field with subtotals
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
   Report 
   09-13-2009, 11:08 PM
Andrey - DD is not online. Last active: 8/25/2011 5:42:49 PM Andrey - DD

Top 25 Posts
Joined on 08-01-2007
Russia, Novosibirsk
Posts 671

DDStaff
Re: Percent field with subtotals

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.


   Report 
GrapeCity » Product Support » DynamiCube Supp... » Re: Percent field with subtotals

Privacy Policy | Copyright © 1997-2012 — GrapeCity, inc.
All trademarks mentioned are the property of their respective owners.