I have a table RepairOrders (see below for a small sample)
Serialnumber RMAnumber Status EndDate ... etc
123-123-123 RMA0001 Booked 12/1/2009
123-123-123 RMA0002 Booked 1/1/2010
123-123-123 RMA0003 Open
234-234-234 RMA0002 Booked 1/1/2010
234-234-234 RMA0004 Open
345-345-345 RMA0002 Booked 1/1/2010
345-345-345 RMA0004 Open
456-456-456 RMA0004 Open
At this point I want to show the following (Serialnumber is the only dimension!)
Serialnumber Number Last End Date RMAnumber
123-123-123 3 1/1/2010 RMA0003
234-234-234 2 1/1/2010 RMA0004
345-345-345 2 1/1/2010 RMA0004
456-456-456 1 - RMA0004
But now comes the hard part (at least I find it hard):
We want to filter on the RMAnumber so you get an overview of the serialnumbers of the open RMA
e.g. RMA0004
Serialnumber Number Last End Date RMAnumber
234-234-234 2 1/1/2010 RMA0004
345-345-345 2 1/1/2010 RMA0004
456-456-456 1 - RMA0004
Sounds easy but the number contains the following:
count( {< Status =, RMAnumber = >}[Serviceorders.Service Art Serial])this since we want all the records for the Serialnumber to be added in the count.
At this moment we get an overview which looks like:
e.g. RMA0004
Serialnumber Number Last End Date RMAnumber
123-123-123 3 1/1/2010 -
234-234-234 2 1/1/2010 RMA0004
345-345-345 2 1/1/2010 RMA0004
456-456-456 1 - RMA0004
seems that the selection made in the dimension is somehow overrulled ... also the not selected items are visible...
Anyone got suggestions
