sum

i have choice field in invoice item that there is "Ordered" and "Pending" and Cancel". when my customer confirmed one item or some items order then i choice "Ordered". i want in invoice table when i filtere "ordered" then sum of net totall be by ordered (net totall ordered be separate field formula). how can do it?