calculate in crosstab?

[r]

Is it possible to do calculations based on the "column" results of a
crosstab query?

For example, I have the following layout:

Job # (row)
Type (col) -- (either AP or PR)
Amt (val)

So my data in the crosstab looks like this:

JOB# PR AP
AB445 5.00 5.00
BB325 7.00 6.00

From table:
AB445 PR 5.00
AB445 AP 5.00
BB325 PR 7.00
BB325 AP 6.00

I want, in my crosstab, to show another column that will ADD the values of
AP and PR into a new field called Total or something.

Doable??? If yes, how?!

 

[Duane Hookom]

Add another column in your crosstab with the Amt as the field and set its
Crosstab to Row Heading.

 

[George Nicholson]

Add another column in your crosstab with the Amt as the field and set its

Crosstab to Row Heading.

probably unneccessary, but...

....(and change the "Totals:" value from GroupBy to Sum)

 

[Duane Hookom]

Good catch George.