N
NeverSeenBlue
I have a table with about 5,000 clients. There are several differen
services that can be offered a client and each service can be given a
infinite number of times. Each service is charged a specific dolla
amount and takes a certain amount of time to complete.
For example:
Client 1 given Service A for $5; time=5 minutes
Client 1 given Service A for $20; time=10 minutes
Client 1 given Service B for $15; time=15 minutes
Client 2 given Service B for $10; time=5 minutes
Client 2 given Service C for $10; time=15 minutes
Client 3 given Service D for $25; time=20 minutes
How can I determine the following:
(1) Percent of time devoted to each service
(2) Percent of dollar amount received for each service
(3) Percent of time and percent of dollar amount devoted for eac
service separated out by client...anotherwards to get a report tha
would state Client 2 received 50% of revenue from Service B and 50
from Service C. Client 2 had 75% of time devoted to Service C and 25
of time devoted to Service B
services that can be offered a client and each service can be given a
infinite number of times. Each service is charged a specific dolla
amount and takes a certain amount of time to complete.
For example:
Client 1 given Service A for $5; time=5 minutes
Client 1 given Service A for $20; time=10 minutes
Client 1 given Service B for $15; time=15 minutes
Client 2 given Service B for $10; time=5 minutes
Client 2 given Service C for $10; time=15 minutes
Client 3 given Service D for $25; time=20 minutes
How can I determine the following:
(1) Percent of time devoted to each service
(2) Percent of dollar amount received for each service
(3) Percent of time and percent of dollar amount devoted for eac
service separated out by client...anotherwards to get a report tha
would state Client 2 received 50% of revenue from Service B and 50
from Service C. Client 2 had 75% of time devoted to Service C and 25
of time devoted to Service B