• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 418
  • Last Modified:

Grand Total in Crosstab

Hello Gurus,

I tried with Row grand total option in crosstab but in vain.

As the summarized fields are 3 and when I select Grand total I'm getting all 3 columns as grand total where I need just one column.

Attached is the report. Can you please help me out pls.

I'm not finding relevant zones in the search.

if possible kindly include SAP data source also.

Pls do not refresh the report.

Thanks,
summary.rpt
0
Akulaj
Asked:
Akulaj
  • 5
  • 4
1 Solution
 
mlmccCommented:
You are using a formula that isn't part of my version of Crystal so it discards all the data.

You are suppressing the row and column totals.  Is there a reason for that?

mlmcc
0
 
AkulajAuthor Commented:
yes I'm suppresing row total..
as it displaying 3 summarized grand total in individual cols.

Is there any way that I can get grand total of those fields in once column.
0
 
mlmccCommented:
Not in the normal cross tab.

mlmcc
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
AkulajAuthor Commented:
what would you advice?.
0
 
mlmccCommented:
Here is a method for building a manual cross tab

http://www.kenhamady.com/form12.shtml

mlmcc
0
 
AkulajAuthor Commented:
Self solved.
0
 
mlmccCommented:
What was the solution?

mlmcc
0
 
AkulajAuthor Commented:
Added Embedded Summary column and solved the issue.
0
 
mlmccCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now