2 Replies Latest reply on Jul 19, 2018 9:45 AM by jordi.torrecillascardona

# Percentage of total number of customers depending on percentage sales with status=1

Hi all!

I have a complicated issue to solve, let me explain you correctly:

1 - First I want to get percentage of sales with status=1 over the rest of status (if there is not status=1 then status 1=0%)

2 - I want to create diferent levels depending on this percentages: (level 1 = % < 0,15, level 2 = % > 0,15)

3 - I want to count the number of customers in each of this two levels and the percentage of total of this two levels

4 - Create a pie chart with each o this levels

This is the data, I attach that too:

• ###### 1. Re: Percentage of total number of customers depending on percentage sales with status=1

Hi, Jordi

Is it something like below? if yes, please find my solution attached.

Hope this helps

ZZ

1 of 1 people found this helpful
• ###### 2. Re: Percentage of total number of customers depending on percentage sales with status=1

Thank you Zhouyi, your response is right!

I had been one week stuck trying different combinations of LOD expresions but then I wasnt able to create the pie chart,

With your mix of LOD expresion and ZN expresion I can do it!

Thank you very much!