Media between Two Column in Matrix

[Max_Broglia]

Good Morning,

I've made a Matrix of a table of invoices like This.

In the last Column (Margin % on Revenues) I've to make the operation Margin (C) / Revenues (A) of the total invoices for company.... How Can I do That?

Tks a lot 

Company	Revenues (A)	Cost(B)	Margin (C)	Margin % on Revenues
Alfa	100	20	80
Beta	150	70	80
Gamma	80	70	10

[az38]

Hi @Max_Broglia 

its unclear now, but try smth like

Margin % on Revenues = 
DIVIDE(CALCULATE([Margin (C)]), CALCULATE(SUM([Revenues (A)]), ALL('Table')) )

do not hesitate to give a kudo to useful posts and mark solutions as solution