Here ya go.... Not a lot of documentation on Embedded formulas for Cross Tabs but this will work great for your situation. I have tested it and received the results you are looking for.
[ul]
[li]right click the white space in top left of crosstab[/li]
[li]select advanced calculation then calculated member[/li]
[li]Click New[/li]
[li]In Description enter AvgOfAvg[/li]
[li]Next to type: Select Row[/li]
[li]Next to Insert Evaluation: Select Before[/li]
[li]Click Edit Insertion Formula and enter[/li]
Code:
if CurrentRowIndex = GetNumRows - 1 then true else false[/li]
[li]Save and close formula editor[/li]
[li]Click Edit Header Formula and Enter "Average" (In Quotes)[/li]
[li]Save and close formula editor[/li]
[li]in Value Formulas click the value in that window then click Edit Value Formula[/li]
[li]Enter the following formula[/li]
Code:
local numbervar a;[/li]
local numbervar rows := GetNumRows-2;[/li]
local numbervar array values;[/li]
redim values[rows];[/li]
for a := 1 to rows do[/li]
values[a] := GridValueAt (a-1,CurrentColumnIndex , 0);[/li]
average(values)[/li]
[li]Save and close formula editor[/li]
[li]Go to Crosstab expert[/li]
[li]Select Custom Tab and Suppress Column Grand Totals[/li]
[li]Click OK to close Cross-Tab Calculated Member Expert[/li]
[/ul]
_____________________________________
Crystal Reports 2011 and XI
Intersystems Cache 2012 ODBC connection