Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Are embedded crosstab summaries the solution? Post Reply Post New Topic
Author Message
bspencer1
Newbie
Newbie


Joined: 26 Nov 2013
Online Status: Offline
Posts: 26
Quote bspencer1 Replybullet Topic: Are embedded crosstab summaries the solution?
    Posted: 16 Sep 2015 at 11:32am
Hello, everyone.  I have an attached an image to this posting of my crosstab.  If you cannot see that image, it can be accessed here:
 
Basically I have a simple cross tab.  The "customer" is asking that I put a formula next to the summary field that basically takes the summarized amount and divides it by the total amount.  In my example in the image, you see that the first person has a total of 203.25 (these are hours).  116.50 hours are billable hours, the others are overhead (OH) hours.  I need to display the percentage of the hour type over the total hours, and I need to display the value to the right as you see it in my example.  I started screwing around with embedded summaries to make this happened but thought I might post this and see if anybody else might tackle it some other way.  It has been over a year since I have been asked to do anything like this, and I am having a memory lapse.  There must be a simpler way I am not thinking of.
IP IP Logged
bspencer1
Newbie
Newbie


Joined: 26 Nov 2013
Online Status: Offline
Posts: 26
Quote bspencer1 Replybullet Posted: 17 Sep 2015 at 6:11am
Update:  I remembered I could create a new grouping formula to get the percentages under the months, but the totals are not correct.  I am now looking for a way to the grand total to calculate the percentages...if anybody has any ideas. 
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.047 seconds.