Skip to Content
author's profile photo Former Member
Former Member

Need help: Supress GroupSummary in CrossTab

Hello everybody,

I need some help with CrossTabs, where I have several row and multiple group summaries. Lets say I have the following structure:

            column 1                        || column 2                       || column 3
row 1       grpSum 1 | grpSum 2 | grpSum 3  || grpSum 1 | grpSum 2 | grpSum 3 ||  grpSum 1 | grpSum 2 | grpSum 3
row 2       grpSum 1 | grpSum 2 | grpSum 3  || grpSum 1 | grpSum 2 | grpSum 3 ||  grpSum 1 | grpSum 2 | grpSum 3
row 3       grpSum 1 | grpSum 2 | grpSum 3  || grpSum 1 | grpSum 2 | grpSum 3 ||  grpSum 1 | grpSum 2 | grpSum 3

In column 1 and column 2 I want to supress grpSum 3, but in column 3, which is a inserted row, I need grpSum 3. I can supress grpSum 3 in column 1 and column 2 by using supress in the formatting section, but if I do so only its content is supressed. The space for grpSum 3 is still reserved. How can I "delete" the reserved space in column 1 and column 2 or is something like that impossible?

Regards

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jul 21, 2011 at 12:54 PM

    If you right click Cross Tab and got to CT Expert - Customise tab

    Here you can suppress column and row total as required.

    Ian

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Sorry, but I don't want to suppress a whole column. I want to suppress a group summary and I also want crystal not to draw space in that column. So I want CR to draw two group summaries in columns 1 and 2 and three in column 3:

      column 1 || column 2 || column 3

      field 1 | field 2 || field 1 | field 2 || field 1 | field 2 | field 3

      I need that third field for calculation purposes in the last column.

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.