Derrick,

This is a very round-about way to do this, very likely there are much cleaner ways.

But maybe this can be a starting point.

Mostly, it has a parameter to select an Item,

then it returns all the orders for customers that bought that Item.

Then previous Order ID is noted by:

IF ATTR([Item])=[SelectItem]

THEN LOOKUP(ATTR([Order ID]),-1)

END

with appropriate addressing and partitioning such that

index count is for each order restarting with each customer id

(see image below).

Then that is fixed across the Customer ID using

WINDOW_MAX([PrevOrderID])

with the same addressing and partitioning as above.

The same is done for the Next order.

Finally, a filter is used to show orders for previous, selected, and next.

Derrick,

Sorry, for not showing that in previous message.

I'm using a parameter to select the item, and then I compare that selected item to the Item dimension.

First,I get just the customers with the Item using [CustomWithItem]:

IF [Item]=[SelectItem]

THEN [Customer ID]

END

Returns Null for all those that don't.

On the table, Null comes up as a row, and I right-click and hide those.

Then for I fix that for all entries of that CustomerID:

{ FIXED [Customer ID]:MAX([CustomerWithItem])}