Page Comparison

...

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_numnumber), and GROUPBY(#RawData!Name).

Using GROUPFIRST(#RawData!Item;#RawData!Order_number), you can return the first item ordered by each customer.

...