AnsweredAssumed Answered

Count 2 Numbers  from one table

Question asked by applelakshan1 on May 29, 2012
Latest reply on Jun 15, 2012 by applelakshan1

Title

Count 2 Numbers  from one table

Post

Hello Guys , this is what i am looking for

I have one table called invoices with drop downmenu, DrDown values are Invoiced paid, Invoiced Notpaid , Quotation, What i prefer to copunt all this 3 Sepratly. 

 

For instance , lets say we have 5 invoices.,

invoice no 1 total 10 (Invoiced)

invoice no 1 total 20 (Invoiced)

invoice no 1 total 30 (Quotation)

 

So what should be the endresult  30 invoices and 30 Pending /quotation 

 

thanks  in advanced.

what i am looking for to filter those values and count  the total sepratly . what  function can i use to acomplish this task ?

Outcomes