Conditional Total

[#1]

I have below table showing Invoice data against Customer ID.

Customer ID	Invoice No	Invoice Value	PAID?
ABC	11	125	NO
PQR	12	130	NO
DEF	13	140	YES
GHI	14	155	YES
JKL	15	146	YES
ABC	16	128	YES
XYZ	17	99	NO
MNO	18	100	NO
PQR	19	135	NO
XYZ	20	198	NO
PQR	21	197	YES
ABC	22	210	YES
DEF	23	150	NO
GHI	24	95	NO
JKL	25	50	NO

I want to get total value of unpaid invoices against each Customer ID.

Can someone please give me script?

The result should be as below

Customer ID	Invoice Value Not Paid
ABC	125
DEF	150
GHI	95
JKL	50
MNO	100
PQR	265
XYZ	297
TOTAL	1082

Thaks in advance.

[swuehl · Accepted solution]

Hi,

use customer ID as dimension and as expression

=sum({<[PAID?]={'NO'}>} [Invoice Value])

assuming that Invoice Value, PAID? are your field names.

Stefan

[#3]

Thanks for your quick response. It's Working fine.