Average On A Matrix Subtotal/ Total

[Ivolution93]

Hello,

Looking for a bit of help

I am wanting to have the totals and sub totals in each group for the Variance Percentage column as an average.

I have the 4 groups of Site, Account Manager, Customer and then Product.

Underneath product there is each pallet/ batch of stock that we sold but displayed as the date.

So i am needing the totals for each group to do an average rather than a total.

[v-cazheng-msft]

Hi @Ivolution93 

Is your problem solved? If you still have question please let me known.

Best Regards

Caiyun Zheng

[amitchandak]

@Ivolution93 , You need to try a measure like

averageX(values(Table[product]),[Variance Percentage])

you can replace Variance Percentage with its calculation