Skip to Content

Cross-Tab: Summarized Field Values & Totals...

Dear All,

I'm working on Crystal Report 2011 and my Data Source is SAP BEx Query. I'm using Cross-Tab for my report. I have a particular scenario to implement for my Cross-Tab.

The Cross-Tab: Summarized Field Values and Columns Total should display (Raw Values (Measure/KeyFigure)), but the Rows totals should display (Net Weight and Gross Weight (Measure/KeyFigures).

When I selected two Measures in Summarized Fields then the Cross-Tab showed both Measures values in Cross-Tab grid Fields Values and Totals. But I want to see Rows Totals being calculated from two different Measures like Net Weight and Gross Weight and the Fields values and Column Totals should use Raw Measure.

1. How should I implement this scenario into my Cross-Tab?

2. Should I use three different Cross-Tabs for three different Measures and ask for selection from user?

3. What is the best approach and how to do it?

Looking forward to valuable inputs.

Many Thanks!!!

Tariq Ashraf

Crosstab.gif (126.6 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Jan 03, 2014 at 10:55 AM

    Do you have a screenshot or Mock-up in Excel of the expected output?


    Add a comment
    10|10000 characters needed characters exceeded

    • Well, you cannot derive totals from fields that are Not a part of the Crosstab.

      There might be workarounds using the Calculated Members + calculating the totals outside the crosstab, however you'll end up pulling your hair trying to do this - not very easy and not neat too.

      Have you thought about creating a Mock Crosstab instead? The only issue with this is that you need to know the number of columns. If the columns are always going to be the same, this is what you should try.


Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.