Show only new customers

[#1]

I have a table with customers revenue with expresions that calculate the revenue per year.

Customer	2015	2014	2013
A	110	100	100
B	120	0	0
C	130	90	80
D	90	100	100
E	80	100	100
F	70	0	0
G	120	0	0
H	105	100	100
I	105	100	100
J	105	100	100

I now wan to show only the new customers, so the customers that have no revenue in 2014 and 2013.

Customer	2015	2014	2013
B	120	0	0
F	70	0	0
G	120	0	0

Can anyone assist?

[sunny_talwar]

Do you have 2014 and 2013 as a separate column in your database or is this just how your data is laid out in a pivot table with year dimension pivoted?

[#3]

The data is laid out in a pivot table with the year dimension pivoted.

The base table is a table witl all sales records that contains an invoice date.

[sunny_talwar]

Try this:

=Only({<Customer = e({<Customer = {"=Sum({<Year = {2014, 2013}>}Data) > 0"}>})>}Data)