Forum Discussion

Ivolution93's avatar
Ivolution93
Frequent Visitor
5 years ago

Average On A Matrix Subtotal/ Total

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.

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Ivolution93 , You need to try a measure like

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

     

    you can replace Variance Percentage with its calculation