Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal report crosstab adding column

Status
Not open for further replies.

sagarNYC

Programmer
Aug 11, 2006
7
US
I have Crystal crosstab 2008 and it looks like this

2oe Lc status 1 LC status 2 .. Total
ab 20 25 45
xyz 10 20 30


I want to add %Total column at the end of crosstab based on formula (LC Status2/Total) * 100. . LC status (Life Cycle Status)

2oe 3oe Lc status 1 LC status 2 .. Total (%Total )
ab IB 20 25 45 55%
xyz TIS 10 20 30 66%

I really can't do it in manual crosstab (by adding group level summaries) because LC status can be more than 40 or so. Any help would be highly appreciated
 
I found solution to this in crystal report 2008 they have introduced new feature where you can use cross tab grid values and use it for calculations later on. really cool. you right click on grid values select first one then select other grid and perform arithmetic on it
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top