Hello Spyros,

The error you see when you have DecimalSumAggregator or Int32SumAggregator is because PercentOfTotalAggregator internally operates with doubles only. I've attached a file with a custom aggregator you can use instead of PercentOfTotalAggregator until we provide a official fix for this issue. Let me know if this works for you.

Regards,
Plamen

Any news on the above issue (PercentageOfTotalAggregator only working with DoubleSumAggregator and not DecimalSum, Int32Sum etc)? Stefan maybe you can help?

UPDATE: It appears to be working ok with silverlight.

There is a problem however.

It seems that PercentOfTotalAggregator works only with a DoubleSumAggregator as one of its parts.

DecimalSumAggregator, Int32SumAggregator will not work.

To reproduce this, do the following changes in the sample project, right where the Amount of Sale Sum and Amount of Sale Percentage measures are added:

• change SourcePropertyName=@"Total"  to SourcePropertyName=@"NumberOfUnits" (which is Int)
• change DoubleSumAggregator to Int32SumAggregator

the percentage measure doeas not appear, though the sum aggregator works correctly

Any thoughts?

Thanks for the example Stefan!

It is a good starting point, though it needs work when there are multiple dimensions in rows or columns.

Will this also work in Silverlight?

Hello both,

I have created a sample project with the fucntionality you want. Basically you need furst to add the sum measure, so that the percentage measure can be calculated based on the sums.

Hope this helps you.