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
AkulajAsked:
Who is Participating?
 
AkulajConnect With a Mentor Author Commented:
Added Embedded Summary column and solved the issue.
0
 
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
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
mlmccCommented:
Not in the normal cross tab.

mlmcc
0
 
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
 
mlmccCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.