Crosstab average column

[Danster]

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.

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?

 

[IanWaterman]

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

https://www.youtube.com/watch?v=RpAEJqFe4IY

Failing that search for Add Calculated Member Crystal Reports

Ian

 

[lbass]

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.

-LB

 

[Danster]

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.