How do i show multiple rows from a sales order when filtering by a single value

[Isaac Schafrath]

There may be a simple solution but I am new to Spotfire universe, so here goes:

I have a large amount of sales order data. 150 columns and tens of thousands of rows. The data pulls line items from sales orders, so there are multiple line items per sales order. Each line item is a different part, with different production and lead times. I need to flag an entire order when a specific part has a long lead time and might lead to a delay. When i flag the order, the filtered display only shows the rows with the flag, not the entire sales order. I want to be able to separate the orders in buckets, then I would like to be able to filter based upon if flaged, then when i click on a specific order nuber to view the details, it shows all the line items from the order, not just the flagged row. Example:

 

 

 

Sales order

Part Number

Lead time

Flag

 

 

10110

15a

5

N

 

 

10110

17g

11

Y

 

 

20552

15a

5

N

 

 

20552

22w

6

N

 

 

20552

64q

22

Y

 

 

32323

15a

5

N

 

 

45891

 

22w

 

6

N

 

 

45891

7k

2

N

 

 

45891

55v

8

 

N

 

 

 

 

In this example, when i filter for flagged orders, i would lose multiple rows from the data. When I click on Sales Order 20552 only one row is displayed. How can I get all 3 rows to be displayed

Thanks

[Gaia Paolini]

You can define a calculated column such as:

Max([Flag]) OVER ([sales order])

and filter against it instead.

This new column will be Y for the entire order when at least one of the part flag is Y, as in sort order Y is greater than N.

Gaia

[Isaac Schafrath]

Perfect, Thank you!