Adding an avg row to straight table

[hopkinsc]

Hi all,

i need some help adding an average row to a straight table. i have 3 teams in my data with  a 'Team Avg' row for each team. what i want is to add a rw to the bottom of my straight table showing the average of the 3 team avg's.

i have added a dummy value to my dimension called 'Total Avg' and now i am trying to find a way of averaging the 3 team avg's and putting that figure against the dummy figure created. if that makes sense!

what i want to achieve is something like the following.

i have attached an example.

many thanks

[hopkinsc]

i get the same value (34). im trying to see if i can get a better example qvw  i can attach

[sunny_talwar]

Yes, that would be much helpful

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample

[hopkinsc]

Hi Sunny, here is a scrambled version of what i am working on.

hopefully that will help. it has been saved with the required selections but in case you need them you need to select:

Year = 2017

Week = 6

type = RegionPerShift

Thanks for your help

[sunny_talwar]

What is the number you are looking to get here? 22.66?

[sunny_talwar · Accepted solution]

Like this

[hopkinsc]

perfect!! thanks so much for your help!