Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Crosstab average column

Crosstab average column

Crosstab average column

I already have a crosstab with the columns and a total at the right (SUM). I just want to add another column AVG.
Exactly the same as this old thread thread149-766735: Crosstab average column.

That thread is around 4 years old and possibly using an older version of CR, so I'm wondering if anyone has any brilliant tips on getting this to work?

RE: Crosstab average column

You do not say what version you have but from 2008 you can add calculated members.
This Youtube video will help


Failing that search for Add Calculated Member Crystal Reports


RE: Crosstab average column

You could either create a manual crosstab or you could add a second crosstab adjacent to the first that only calculates the average. You would have to format the crosstabs to relative positions in the section expert so that the second crosstab would move as the number of columns in the first changes. You can also format the left boundary line of the second crosstab to be hidden, using the crosstab expert.


RE: Crosstab average column

I'm using v2013, latest service pack.
I looked at calculated member but I couldn't get it to show just for a grand total.
lbass, great idea. I'll fiddle about with a second crosstab - that might just do the trick.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close