S
sabunim
I have a table that will be used to create a report. Within this table are 3
main fields: Range #Cust Perct TotPerct
$0 50 25% 25%
$1-$5 20 10% 35%
$6-$10 10 5% 40%
The data above is just a quick example of the table and its data for the
purpose of this question. In the example the total #Cust is 200 so the
percentages are correct. However what I am looking for is the percentages to
accumulate so that I can see at what range do I reach a certain level of
customers. Using the example above, the fourth column needs to show that at
the $6-$10 range I have already reached 40% of the customers and this
cumulative percentage will continue downward until I reach 100%. The
calculation in the fourth column is what I cannot figure out. Any help is
very much appreciated. Thank you.
main fields: Range #Cust Perct TotPerct
$0 50 25% 25%
$1-$5 20 10% 35%
$6-$10 10 5% 40%
The data above is just a quick example of the table and its data for the
purpose of this question. In the example the total #Cust is 200 so the
percentages are correct. However what I am looking for is the percentages to
accumulate so that I can see at what range do I reach a certain level of
customers. Using the example above, the fourth column needs to show that at
the $6-$10 range I have already reached 40% of the customers and this
cumulative percentage will continue downward until I reach 100%. The
calculation in the fourth column is what I cannot figure out. Any help is
very much appreciated. Thank you.