Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2016 : Report Design  
Message Icon Topic: Custom Group Based on Group Sum Post Reply Post New Topic
Author Message
igendreau
Newbie
Newbie


Joined: 15 May 2008
Online Status: Offline
Posts: 12
Quote igendreau Replybullet Topic: Custom Group Based on Group Sum
    Posted: 16 Oct 2018 at 5:32am
I'm grouping sales numbers, and I want to do something like determine whether a number is 0-50K, 50k-99k, or 100k+. I know I could do a custom group to handle that on the detail level.

The challenge is that I want to custom group other groups. On the detail level, I have each individual sale. Those detailed records are grouped by customer, and that group has a sum of all the sales. What I want to do is group each customer into one of my 3 categories. So I'd be using the group sum number as my qualifier for which group they go in, which Crystal doesn't want to let me do.

Any good way to accomplish this?
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1431
Quote kevlray Replybullet Posted: 16 Oct 2018 at 7:37am
Maybe, formulas are done before grouping.  The sum would have to be in a formula (never tried this, hopefully it will work).
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.031 seconds.