Suming using a crosstab

[aarondewberry]

All. I have a crosstab table in my report. The column header is processyear ie 2004,2005,2006 - the Row header is propertynumber and the body is the amountofbilling.
What I want to be able to do is have a sum on the end of the cross tab that gives you the amountofbilling in 2004 minus the amountofbilling in 2005. Can this be done?

 

[blom0344]

Adding a calculation to the body will add a column at the end of the crosstab.
There you use a variable that reads:

 = (Sum(<amountofbilling>) where <year> = 2004) -
   (Sum(<amountofbilling>) where <year> = 2005)

Ties Blom

 

[xlbo]

Alternatively, if you can handle having the calc to the left of the data, you can simply insert a column next to your propertynumber and put the formula in there

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question