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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cross Tab - Summary field

Status
Not open for further replies.

saran26

Programmer
May 20, 2008
173
US
Hi All,

I have a summary field in my cross tab called "effort" which i listed as a "Max" as the summary.

Now in the Row wise total, it shows the max value, But I want to display to the total of all values in that row

For example

I have this

Project Total Jan Feb Mar

1 40(MaxS) 20(MaxS) 30(MaxS) 40MaxS)


But I want to show total as 90.

Please help me out.

Thanks
Saran
 
Please always identify the row, column, and summary fields uses in your crosstab, using {table.field} format. Also always identify your CR version.

-LB
 
Hi LB

sorry about that.

My crystal report version is 11.0.0

Row Field is ClearQuest.name

Column fied is ClearQuest.Monthly Effort

Summary field is Max of @effort (it is a formula field)


Thanks

saran
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top