If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Show top 5 members and sum other members on pie chart

Started by b737, 25 Sep 2015 04:05:52 AM

Previous topic - Next topic

b737

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