Sales in Percentage

[#1]

Hi,

Please Help Me,

My Requirement is to show top 20% sales not top 20 sales .

the user will give input value in input box like he want to see top 10% or 20% ie

we are not suppose to use dimension limites only by using input box

[sinanozdemir]

Quick question: When you say top 20%, would that include only 0% to 20% or only the items within 20% to 29%? I ask this because in your example every item has a fraction.

Thanks

[sinanozdemir]

Let me make my question clear.

When you say top 20% which of the records you are expected to show?

[maxgro]

Try with a button and a Pareto select

Replace percentage with the variable of the input box

[#5]

Thanku for u response Ozdemir,

i want to see like contribution fo a particular country in my profit . in this case i want to see only  contribution percentage

abovei posted is sample data atleast show me top 5% countries contributing in profit.

eg:

in one country there are 3000 stores then  top 10 sales will give  top 10 values but top 10% values  count might be differ

[maxgro · Accepted solution]

PFA

[tyagishaila]

Try it;

Use calculated Dimension in place of custCountry

Add Calculated Dimension

=aggr(if(rank( sum(unitsSold)/Sum(Total unitsSold))>= 0.20, custCountry), custCountry)

in place of 0.20 you can use variable..

and this variable value can be entered by user in Inputbox.

Let me know is this working or not?