calculate in crosstab?

  • Thread starter Thread starter r
  • Start date Start date
R

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?!
 
Add another column in your crosstab with the Amt as the field and set its
Crosstab to Row Heading.
 
Add another column in your crosstab with the Amt as the field and set its
Crosstab to Row Heading.
Click to expand...

probably unneccessary, but...

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