|  | Crosstab query help | | |
| | | kidkosmo |  |
|  Posted: Tue Sep 23, 2008 8:22 pm Post subject: Crosstab query help |  |
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 |
| |
| | | Allen Browne | |
| | Posted: Wed Sep 24, 2008 12:47 am Post subject: Re: Crosstab query help | |
| |  | |
You could add another field to your crosstab that contains an expression
that calculates the grand total. Use a subquery, or a domain aggregate
function such as DCount() or DSum(). Make it a RowHeading, Expression.
Alternatively, you could do this in the report. Put a text box in the Report
Header section. You can then refer to it in the control source of another
text box that calculates the percentage.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - LINK
Reply to group, rather than allenbrowne at mvps dot org.
"kidkosmo" <kidkosmo2@yahoo.com> wrote in message
news:6ab21054-25cc-44de-8f61-6161e0d3da0a@l43g2000hsh.googlegroups.com...
| Quote: | 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 |
|
| |
|
|
