cancel
Showing results for 
Search instead for 
Did you mean: 

Average as a Calculated Member (Row)

0 Kudos

I need to create a manual "Average" Row at the bottom of my Cross Tab that AVG the values.

I have tried a few different things but I am not having much success.

Any suggestions or tips would greatly be appreciated.

0 Kudos

I have been able to get the AVG row inserted (and a blank separation row), but I am unable to get the AVG to display below the Total.
Is that even possible?

Insertion Formula is: CurrentRowIndex = GetNumRows - 1

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

I had to suppress the Row subtotal and create a Calculated Member (total).