on 06-20-2022 9:40 PM
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
I had to suppress the Row subtotal and create a Calculated Member (total).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.