Forum Discussion
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, Cus...
Ivolution93 , You need to try a measure like
averageX(values(Table[product]),[Variance Percentage])
you can replace Variance Percentage with its calculation