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 IHere's another demonstration of my data:
| Taken from another table | ||||||
| Month | Code | Name | Product | Sales per product | Total sales 2018 | Solution needed |
| January | 1 | One | PP | 2 | 220 | 220 |
| January | 1 | One | SS | 3 | 220 | |
| January | 1 | One | YY | 4 | 220 | |
| January | 1 | One | MM | 9 | 220 | |
| January | 2 | Two | PP | 1 | 167 | 167 |
| January | 2 | Two | SS | 4 | 167 | |
| January | 2 | Two | YY | 7 | 167 | |
| January | 2 | Two | MM | 2 | 167 | |
| January | 3 | Three | PP | 3 | 701 | 701 |
| January | 3 | Three | SS | 1 | 701 | |
| January | 3 | Three | YY | 3 | 701 | |
| January | 3 | Three | MM | 8 | 701 | |
| February | 1 | One | PP | 2 | 220 | 220 |
| February | 1 | One | SS | 3 | 220 | |
| February | 1 | One | YY | 4 | 220 | |
| February | 1 | One | MM | 9 | 220 | |
| February | 2 | Two | PP | 1 | 167 | 167 |
| February | 2 | Two | SS | 4 | 167 | |
| February | 2 | Two | YY | 7 | 167 | |
| February | 2 | Two | MM | 2 | 167 | |
| February | 3 | Three | PP | 3 | 701 | 701 |
| February | 3 | Three | SS | 1 | 701 | |
| February | 3 | Three | YY | 3 | 701 | |
| February | 3 | Three | MM | 8 | 701 |
Jimmy801
Community Champion
Community ChampionHello Laufer_Israel
have you been able to solve the problem with the replies given?
If so, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
All the best
Jimmy