Hi,
I have Product hierarchy with more then 10 products (members). Since in average 5 products represent more than 80% of sales, I want on pie chart present those top 5 members (Product 1, 2...5) and other to sum and to put on pie chart - Others. I want this, because otherwise I have on pie chart 15 products where 10 products (Product 10, 11....) have 0.5% sales and it is not nice to see on graph.
Note, that those top products are not always the same, so I need to dynamically change products.
Thanks