Crosstab query help

[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

 

[Allen Browne]

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.