Pivot table Grand Total Question

[#1]

I have created the following command to give me an average for each of my nine shops:

avg(aggr(sum({$ <TrnsDateYear={2013}>} Quantity)/count({$ <TrnsDateYear={2013}>} WorkOrderID),Shop,TrnsDesc))

This works perfectly.  What I want to do now is create an avg of these 3 shops.  So if:

avg(aggr(sum({$ <TrnsDateYear={2013}>} Quantity)/count({$ <TrnsDateYear={2013}>} WorkOrderID),Shop,TrnsDesc)) produces:

Carp - 1.20

Elec - 1.15

Plumb - 1.16

I want to see following:

Carp - 1.20

Elec - 1.15

Plumb - 1.16

Avg Total - 1.17

Can I do this in one pivot graph?

Thanks,

David

[#2]

Thank you so much.  It worked.  This is awesome.

David

[SergeyMak]

Hi David,

To help other people with similar issues, could you mark the answers as correct and helpful, if you find a solution.

Regards,

Sergey

[#4]

Hi Sergey

THank you for the reminder.  I need to mark the second one right because that was the fix.  I will do it in a bit.