Friday, March 23, 2012

is this layout in analysis services possible?

Hi,

I have a cube which should show top 10 products and a percentage for that versus the overall performance of the product.

Can this be possible?

Amount Percentage

Product 1 1000 5%

Product 2 2000 10%

Product 3 1500 7.5%

.

.

.

Product 10 4000 20%

SubTotal for top 10 10000 50%

Total 20000

This is definitely possible, showing the sub total and grand total might be tricky in a pivot table, but it is not too hard with an MDX query.

No comments:

Post a Comment