BOMs
  total total   distinct   cases
item   rows distinct status active NRND LTB obsolete YTEOL open pending resolved
-
Customer 1
59 45   40 3 1 1 0 0 1 12 1 0 12
-
Customer 1
59 45   41 3 1 0 1.0 0 0 13
-
Project 1
35 27   24 1 1 1 0 0 1 9 1 0 9
-
Project 1
35 27   24 1 1 0 1.0 0 0 10
-
Card 1
21 18   16 1 1 0 1.0 0 0 5
-
BOM 1
11 11   11 0 0 0 6.4 0 0 2
-
BOM 2
6 6   5 1 0 0 1.0 1 0 0
-
BOM 3
4 4   3 0 1 0 2.2 0 0 2
-
Card 2
14 12   10 1 0 1 0 0 1 4 1 0 4
-
Card 2
14 12   12 0 0 0 3.4 0 0 5
-
BOM 4
9 9   8 0 0 1 0 0 1 2 1 0 2
-
BOM 4
9 9   9 0 0 0 6.0 0 0 3
-
BOM 5
5 5   5 0 0 0 3.4 0 0 2
-
Project 2
18 18   16 2 0 0 3.4 0 0 1
-
BOM 6
18 18   16 2 0 0 3.4 0 0 1
-
BOM 7
6 6   6 0 0 0 6.4 0 0 2
LogoutBOMs
1 part pending approval
Something like this would be the main interface for both customers and OM specialists. Click items to expand and collapse them. If you haven't approved a proposed solution yet, notice the red data and open case on BOM 4 and the alert in the top right. Click "Details" on BOM 4 to drill down, or the alert box.