Print Page | Close Window

Calculating difference in crosstab

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=5877
Printed Date: 02 May 2024 at 6:11am


Topic: Calculating difference in crosstab
Posted By: julisimo
Subject: Calculating difference in crosstab
Date Posted: 24 Mar 2009 at 9:51am
I need help!

I got a crosstab, and I'm trying to show the difference between rows. I got something like this:

                 BatchA  BatchB Total
Jan 2008       5          1          6
      2009       2          2          4
     TOTAL      7          3         10

Feb 2008       0          1          1
       2009      1          1          2
       TOTAL    1          2          3

In the total ROW counting the row I want to subtract them.
I don't want 5+7=7
I want 5-2=3

Is there a way to get this result?



Print Page | Close Window