...
Example
Given the following raw data:
| Customer_number | Name | Order_number | Item |
|---|---|---|---|
| 2535 | Jon | 101544 | Zamioculcas |
| 2888 | Mike | 101567 | Spider Lily |
| 2535 | Jon | 101643 | Datura |
| 2535 | Jon | 101899 | Dahlia |
| 5788 | Jon | 102003 | Snapdragon |
| 2888 | Mike | 102248 | Marguerite |
| 2535 | Jon | 102282 | Windflower |
| 2888 | Mike | 102534 | Elephant's Ear |
| 2535 | Jon | 102612 | Chinese Evergreen |
| 5788 | Jon | 102617 | Begonia |
| 5788 | Jon | 102765 | Starfish Plant |
| 2535 | Jon | 102947 | Hare's Foot Fern |
| 2535 | Jon | 103001 | Venus Flytrap |
| 3545 | Monique | 103006 | Red Flame Ivy |
First create Create a group, using GROUPBY(#RawData!Customer_number), and GROUPBY(#RawData!Name).
...
Using GROUPFIRST(#RawData!Item;#RawData!Order_number), you can return the first item ordered by each customer.
...