Crosstab average column

Danster · Feb 20, 2018

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 · Feb 20, 2018

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 · Feb 20, 2018

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 · Feb 20, 2018

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.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Crosstab average column

Danster

Technical User

IanWaterman

Programmer

lbass

Technical User

Danster

Technical User

Similar threads

Part and Inventory Search

Sponsor