Forum Discussion
Laufer_Israel
Helper I
Helper IReturns only first row with lookupvalue
Hi all, I have a table as can be seen below and I would like to see only the first row for "Total sales 2018" column. It is important to note that "Total sales 2018" is a data which has been taken ...
Laufer_IsraelHelper I
Helper IThank you Jimmy for your prompt comment.
Since the data in my question is only an example of my issue, your recomendation is'nt valid on this case.
Actually what I would like to do, is to add another column that will show only the first row from "Total sales 2018" for each customer and will leave the rest of the rows for each customer blank.\
Does it possible??
Laufer_IsraelHelper I
Helper IThe right column it is what I am looking for.
| Code | Name | Product | Quantity | Total sales 2018 | Total sales 2018 |
| 1 | One | PP | 2 | 220 | 220 |
| 1 | One | SS | 3 | 220 | |
| 1 | One | YY | 4 | 220 | |
| 1 | One | MM | 9 | 220 | |
| 2 | Two | PP | 1 | 167 | 167 |
| 2 | Two | SS | 4 | 167 | |
| 2 | Two | YY | 7 | 167 | |
| 2 | Two | MM | 2 | 167 | |
| 3 | Three | PP | 3 | 701 | 701 |
| 3 | Three | SS | 1 | 701 | |
| 3 | Three | YY | 3 | 701 | |
| 3 | Three | MM | 8 | 701 |