Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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?
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.
Try this:
=Only({<Customer = e({<Customer = {"=Sum({<Year = {2014, 2013}>}Data) > 0"}>})>}Data)