accumulate the sales

[#1]

hi all,

i have a straight table which shows customers versus their sales

Customer	Sales
Customer A	100
Customer B	120
Customer C	300
Customer D	230

The total sales here is 750

i want to add a slider and the user to select the value accumulate to the total sales is colored with red

i.e if the customer select 40 from the slider that means hw wants to give a red color to customers who accumualte to 40% of total sales which is 40*750/100=300

so, customer A,Customer B and Customer C will be highlighted by Red Color

how to make this??

[MarcoWedel]

why do customer A,Customer B and Customer C accumulate to 40% of total sales?

Is it because of the order in this table? Does this mean, customers sorted by name do have to accumulate to 40%?

please clarify.

thanks

regards

Marco

[#3]

yes, it's according to their sort

[antoniotiman · Accepted solution]

Hi Mona,

see attachment.

Regards,

Antonio

[MarcoWedel]

Hi,

one solution:

hope this helps

regards

Marco