100% on Pie Chart for Top 10 Members of a Dimension

[#1]

Hi,

Maybe some might have already posted this question sorry for re posting since i didn't get the required answer from other discussions .

I want to display the Top 10 Members in a pie chart in % and their total should be equal to the 100%

My dimension is country and measure is

"sum(Sales_Gross)/Sum(Total Sales_Gross)"

Please suggest me !!!..

I tried formulas like "=if(Aggr(sum(Sales_Gross)/Sum(Total Sales_Gross),country) <= 10, country)" as a calculated dimension and my measure is sum(Sales_Gross)/Sum(Total Sales_Gross)

Please guide me how can i achieve it , i am unchecking the "Others option" too

Thanks for your Time !!!

[MK_QSL · Accepted solution]

You can get by changing your object dimension and expression as below

Dimension

country

Expression

SUM({<country= {"=Rank(SUM(Sales_Gross))<=10"}>}Sales_Gross)

/

SUM(TOTAL {<country= {"=Rank(SUM(Sales_Gross))<=10"}>}Sales_Gross)

[#3]

Hi,

This is quite simple and without any formula possible. You only have to click on the Dimension Limits tab and check "Show only" and choose "Largest 10" and uncheck "Show Others"

Then click on the "Expressions" tab and check "Relative" and "Values on Data Points"

The result should be a pie chart showing you the top 10 of your dimension with their total of 100%

Regards,

Claus

[cjohnson]

Try using the "Relative" button under Expressions:

Using this and setting Dimension Limits to 10 (and unchecking "Show Others") should give you the correct result:

Does this give you what you are looking for?

[#5]

Hi Reinhard,

Thanks for your time !! . Yup i have changed my expression to as you what you have suggested !!! Your answer is really Helpful !!

[#6]

Hi Johnson,

Thanks for your time !! . Yup i have changed the expression to the relative !!! Your answer is really Helpful !!

I am really Thankful

[#7]

Thanks Manish !! It is helpful but will it effect the performance ?