Hi Stefan,

Thanks for your reply... Do you have any sample solution for my problem? I went through feature browser but I could see only Avg, Max, Min & Sum aggregators and not percentage of total... :(

I am looking for result something like shown in attached image....

Thanks.

Rohan

Any update on this?

It is a very important requirement from my customers to able to show percentage of measure, calculated accoring to current slice / filter.

The sample for FlatDataAggregators does not really answer the question.

Thanks!

So far, no luck... I am also struggling to achieve the result as shown in picture using pivot.

By any chance, if you manage to solve this, could you please send me sample solution? If I get one, I'll update it here.

Thanks,

Rohan

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.

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 Spyros,

Thank you for your feedback. I am glad that you resolved your issue and I believe that other community members may benefit from this as well.

Thanks again.

...and with the latest service release it works!

I am now evaluating performance, and I have also noticed that the behaviour of the PercentOfTotalAggregator seems a bit strange, but the basic idea is now applicable.

Thanks!

Hello Spyros,

The next service release is scheduled for the end of June, but I cannot guarantee that the fix will be included there.

Thanks stefan, I am waiting for the fix.

I am also evaluating the solution offered by Plamen, and although it techically works, there is a huge performance hit on large cubes.

I suspect the constant casting to double is resource intensive.

Do you have any timeframe for the service release?