Just go to Analysis>Total>Show Row Grand Totals.
You would get Grand Total. Clicking on that column header will open a Menu saying Automatic, Change That to Average.
Averages across row.twbx 1.2 MB
Thank you Deepak for the solution !
Worked very well for me, however this also brings me to one follow up question.
I want to use the Grant Total numbers to plot in the World Map. I have plotted another set of data on the map too, hence I understand the basics.
What I am struggling with is that I do not see any Grand Total numbers in the Measures frame. How do I make that as a calculated field or measure value so that I can use it for plotting to ?
Many thanks !