Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Crosstab Percentage Post Reply Post New Topic
Author Message
Seracht
Newbie
Newbie


Joined: 19 Sep 2008
Online Status: Offline
Posts: 1
Quote Seracht Replybullet Topic: Crosstab Percentage
     Posted: 19 Sep 2008 at 2:55am
Hi,
I have a crosstab that has the following:
 
 
              200610         200611          200612    ....
200611     5    10           5    15           1        2
200612     5     7            5     3            1         7
200701     5     3            1    6             1        4
 
The columns are cohorts, while the rows are dates. Essentially, there are multiple records for 1 date and multiple dates for 1 cohort.
 
Cohort -> Date -> Records
 
I summed up two different columns grouped on cohort and date, using a running total. Now I need to divide those two running totals. Any advice?
 
Thank you
IP IP Logged
HolyCow
Newbie
Newbie
Avatar

Joined: 18 Sep 2008
Location: United States
Online Status: Offline
Posts: 15
Quote HolyCow Replybullet Posted: 19 Sep 2008 at 7:12am
Use a mock Xtab (create a subreport and make the subreport look exactly like your xtab) (not trying to be smart here, I just recently learned about it myself, and am still having trouble with another aspect) to do it and you will be able to better control the running totals and work with things intermiadtely.
IP IP Logged
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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | BAEZL

© 2004-2026 Brian Bischof. All Rights Reserved.