Ranking problem

[Former Member]

Hello,

I want to make pie chart with our 5 top customer.

I want to show in the chart the percentage of sales for each of the five largest customers from the total sales and not just from the five largest customers sales.

How to do this?

Thank you

Elad

[Former Member · Accepted solution]

Hi,

Lets say your measure is sales.
Create a variable percentage = ([sales]/Sum(NoFilter([sales])) In Report)*100

Create a table using the customer and percentage.
Apply ranking to this and based on sales.

Turn the table to Pie Chart.

Thanks
Gaurav

[Former Member · Accepted solution]

Thank you Gaurav,

I try,

This is my variable:

= ([Net realized turnover]/Sum(NoFilter([Net realized turnover])) In Report)*100

What dos it mean (NoFilter)?

The number is looking not correct.

Elad

[Former Member · Accepted solution]

nofilter is a function which will allow  to consider any other values which are not considered when you are applying a report level filter on a report.

For eg. If you have three countries C1,C2,C3 and sales for these countries.

If I apply a filter on country to display  C1 and C2, I will see revenue for these countries only in the footer(if you re applying a sum).

But If I want the sum to include C3 also in calculation I will use nofilter.

Can you give me the data set you have and process you followed while using this variable.

My understanding is you have lets say 10 countries and there net realized turn over.

When you apply ranking on country lets say TOP 3 based on turn over, you only see top 3 values .

If you calculate percentage than it will only show percentage which is calcualted among these three countries.

So when I apply nofilter in sum(net turn over), it also considers other countries turn over in the calculation.

If you can tell the  sample data and workflow. It would be easier.

Thanks

gaurav

[Former Member · Accepted solution]

Also what is the measure you slected for applying the rank.

The rank should be based on Net realized turnover and not the percentage.

One more point, your mouse over in pie chart will give you current percentage.

The one in display will give you the breakup of 100 %(its  a pie chart behavior).

[Former Member · Accepted solution]

Hello and thank you again,

I have a lot of customers,

I wand to display in pai chart the top 5 of them but I want to display in the chart the percentage for each of them from the total of customers (and not only from the 5 high customer group)

Elad

[Former Member · Accepted solution]

when you show pie chart your top 5 will be plotted with a combined scale of 100% to get a Pie...

If that is ok then try the approach below... other wise change the chart to a bar chart or something else

You should create a variable and use this variable to plat your chart... which will make the chart not combine 100% but as you are showing number in a pie it will still be a circle

=[measure]/(Sum( NoFilter([measure])) in report ))

[Former Member · Accepted solution]

Hi Elad,

There is other way you can show this in pie chart.

You can map all other customers other than TOP 10 into a row as "others", and can display in the pie chart.

I have created a blog for this, if this helps you.

http://scn.sap.com/community/businessobjects-web-intelligence/blog/2013/12/04/how-to-add-others-in-a...

Thanks

Gaurav