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