Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Adding custom column to crosstab Post Reply Post New Topic
Author Message
rajasan77
Newbie
Newbie


Joined: 17 Apr 2009
Online Status: Offline
Posts: 6
Quote rajasan77 Replybullet Topic: Adding custom column to crosstab
    Posted: 30 Sep 2009 at 2:54pm
Hi,
 I have a crosstab with 7 column(for the days of the week). I want two more columns to be added based on the value of the existing 7 colulmns.
 
Ex:(What I have)
 
Group       total Sun Mon Tue Wed  Thu  Fri  Sat
aaa             5      1     2    0     0       0     3    0
 
I want like this
 
Group       total Sun Mon Tue Wed  Thu  Fri  Sat    #ofdays   Avg per day 
aaa             5      1     1      0    0       0    3     0        3               0.43
 
Note: #ofdays means, # of days that has non zero.
 
Can any one please help me???
IP IP Logged
Jyothi Yepuri
Senior Member
Senior Member


Joined: 11 May 2009
Location: Australia
Online Status: Offline
Posts: 127
Quote Jyothi Yepuri Replybullet Posted: 30 Sep 2009 at 4:13pm
you can not do this Cross tab...Instead try grouping by Group and create formulas for each columns(Mon..Sat, #ofdays, Avgperday)


HTH,
Jyothi

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.