SAP BO ,WEBI Charts: Want to display top 10 departments

[Former Member]

Hi Guys.

I am new to webi charts,

In Webi charts, I want to display the top 10 departments who are spending more in printing with amount, if possible year wise.

But the chart which i created it is not looking relevant and very confusing.

And in Legend it is displaying all the departments and that to it is not fitting in one page,

So i am thinking to display only top 10 departments, Can you help me.

we are using 3 version

[Former Member · Accepted solution]

You can do this with the Ranking function of Webi.

Select the chart, then select the Rank icon in the toolbar, and add the rank. For example, you'd select the top 10, based on a measure of amount, for the dimension of year.

Hope that helps.

[Former Member · Accepted solution]

Thank you so much David, Its magic and solved.

I am struggling with this from past 1 day...

[Former Member · Accepted solution]

I am not able to get this option ..can you pleas ehelp