I want to calculate “Salse Portion”:
How do you do that?!
It sounds like you’re looking for Custom Expressions:
but i am looking for a SQL function for this problem
This is the way to the solution:
SELECT SUM(netIncome) AS 'net ’
,net/ ( SELECT sum(netIncome) from ALLOrders ) as “percent to total”
group by category