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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

repeated conversion of data summarized into rows and columns 4
Add queries to new crosstab every month 5
Problems with Crosstab Query 4
Sort 2
crosstab query without calculations 4
How to Union Crosstabs... 1
Help creating crosstab query 1
multiple results display after filter function 1

Back
Top