1 of 1 people found this helpful
Have you tried below approach:
Analysis -> Total -> Show column grand total.
This will display the grand total.
To get grand total as average navigate to below path:
This will give you the desired result.
I have followed above approach to get avg in grand total in below pic.
Ahhh that worked - I had to drag the PIL to the Text Mark and then do what you say.
I don't know what difference moving it would make ? but thanks anyway we got there :-)