K
kidkosmo
Hi, All,
Is there any solution within a crosstab query or a report that will
calculate a percentage of the total number of records? For example,
below is a snippet of the count data established from my crosstab
query. I am hoping the calculate the percentacd of "Client Resolved,
etc" based on the entire total of incoming tickets rather than the
total of that row (ie. 114/724 rather than 114/494).
Any ideas?
Cause Code Total Of ID Client Resolved Connect re-
established
CPU - BU not receiving orders 494 114 45
CPU - BU Proceedure 158 10
CPU - Client refusing results 60 5 33
CPU - Client ugrading interface 12 2
Is there any solution within a crosstab query or a report that will
calculate a percentage of the total number of records? For example,
below is a snippet of the count data established from my crosstab
query. I am hoping the calculate the percentacd of "Client Resolved,
etc" based on the entire total of incoming tickets rather than the
total of that row (ie. 114/724 rather than 114/494).
Any ideas?
Cause Code Total Of ID Client Resolved Connect re-
established
CPU - BU not receiving orders 494 114 45
CPU - BU Proceedure 158 10
CPU - Client refusing results 60 5 33
CPU - Client ugrading interface 12 2