Print Page | Close Window

CrossTab Puzzled

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=14760
Printed Date: 29 Apr 2024 at 2:37pm


Topic: CrossTab Puzzled
Posted By: vbwrangler
Subject: CrossTab Puzzled
Date Posted: 24 Oct 2011 at 9:28am

I have a Crosstab that I have gone as far as I can tell toward the goal; and I would appreciate your experience if you have solved one of these two problems.

#1  On a crosstab the requirement is that I have additional calculated columns in the Grand Total Column based on the totals.  Such as the profit below which would be Sales X Profit% = $210,000 X 0.60 = 12.60.

Product  Sale Price  Profit             Jan         Feb        Mar…    Nov        Dec        Profit       Total

Cardinals Tickets       [ 6.0%]          50,000   66,000   77,000   15,000   2,000       [12,600] 210,000

Cardinal Ball Caps      [2.0%]          2,000     8,000     18,000  9,000      3,000       [800]        40,000

 

#2   The profit figure printed in the end of the row title.  I had this worked out at one point and have lost it since.



-------------
Thanks
vbwrangler



Print Page | Close Window