Grand total of pivot table

andyRowan

I have a beast mode that is taking sales and dividing by number of chairs*number of locations.

It looks good at the detail level but the total level is just summing rather than taking the total number of sales and dividing it by the total number of chairs.  

TY net sales is a sum of sales where a flag = Ty

Number of stores is a count distinct stores where the flag = TY

Number of chairs is attached to each record based on the store location. The report is grouped by number of chairs

2

3

4

So for the total row I need my denominator to be

Total number of chairs=(2*51) + (3*17) + (4*0).

Currently this is my formula.
`TY Net Sales $`/(`# of Chairs`*`TY Number of Studios`)

IMG_3946.jpeg

DashboardDude

@andyRowan,

I took a look and made you this video. I think you need to add SUM in your formula:

https://www.loom.com/share/6100a780e6c94949b60c7565ba2a20eb?sid=8539a057-02f3-43d4-80b2-b2e451aedfa5