Sum GM% in Stacked Bar

[salleninsd]

Hello,

I am looking for the syntax to aggregate the total GM% in a stacked bar. If I drill down to one customer, the GM% is correct.  When all are selected, it is adding all the GM% numbers up, together.  Not sure of the correct syntax in the expression?

Thanks in advance for any advise!

sum(NetRevenue)/sum(TotalRevenue)

[salleninsd]

Sorry, I meant to tell you that Net Revenue = Total Revenue minus Cost

Thanks again, you are both my heroes!