Hello,
I'm trying to create a crosstab report that reports orders by state for clients.
Something like this, which is easy at first.
California Michigan
Client 1 100 50
Client 2 20 10
However I need to break that down by turnover time with is a measure of when the order started and was completed and is measured in hours. Also the percentage of this turnover in relation to the total.
Something like...
California Michigan
Client 1 100 50
Under 48 hours 25 25% 25 50%
48 to 71 hours 25 25% 0 0%
72 to 95 hours 25 25% 25 50%
95 to 119 hours 25 25% 0 0%
Client 2 20 10
Under 48 hours 10 50% 5 50%
48 to 71 hours 10 50% 0 0%
72 to 95 hours 0 0% 0 0%
95 to 119 hours 0 0% 5 50%
My cells would have to be calculations based on hours. My question is how do you create a Row = Under 48 and have the proper cells (10 50%) line up accross from it. Anyone have any suggestions?
Thanks in advance.
Consultants Club Corp.
I'm trying to create a crosstab report that reports orders by state for clients.
Something like this, which is easy at first.
California Michigan
Client 1 100 50
Client 2 20 10
However I need to break that down by turnover time with is a measure of when the order started and was completed and is measured in hours. Also the percentage of this turnover in relation to the total.
Something like...
California Michigan
Client 1 100 50
Under 48 hours 25 25% 25 50%
48 to 71 hours 25 25% 0 0%
72 to 95 hours 25 25% 25 50%
95 to 119 hours 25 25% 0 0%
Client 2 20 10
Under 48 hours 10 50% 5 50%
48 to 71 hours 10 50% 0 0%
72 to 95 hours 0 0% 0 0%
95 to 119 hours 0 0% 5 50%
My cells would have to be calculations based on hours. My question is how do you create a Row = Under 48 and have the proper cells (10 50%) line up accross from it. Anyone have any suggestions?
Thanks in advance.
Consultants Club Corp.