sub total columns with in cross tabs

within a crosstab is it possible to create columns that subtotal columns within the cross tab?  For example if a crosstab generates col!, colB, colC, Total,  could i create colA, colB, colAB (which is a sub total of the colA and colB..... colC, Total.
Mike JohnsonBusiness Inteligence DeveloperAsked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
I don't think so.

You could create a formula in Crystal that has values from both fields thn add that in the cross tab.

Do you have a record with all columns?

mlmcc
0
 
Mike JohnsonBusiness Inteligence DeveloperAuthor Commented:
Not sure I understand your question mlmcc "Do you have a record with all columns".  I think i tried something like you're suggesting.   Could you elaborate on your suggestion, please?
0
 
mlmccCommented:
Does each record refer to a single col like A, B or C
or do you have a record like

ColA    ColB   ColC  etc?

mlmcc
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
Mike JohnsonBusiness Inteligence DeveloperAuthor Commented:
the former i have a formula that groups a field from each reocrd  cola , colb, colC.  That part's working fine, but my report specs have a summary column summarizing cola, colB, with colAB, then colC follows.
0
 
mlmccCommented:
You could create a formula like

{ColA} + {ColB}

You should be able to add that formula to the cross tab.
A lot of formulas to add.

mlmcc
0
 
weichunglowCommented:
Possible in CR 2008 using calculated members.

By Calling function like GridValueAt
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.