Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
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
Found a not so nice solution ...
Now I check with the isnull function if the column is empty ... if so I don't display the value ...
This way all expresions show null ... and the row is not displayed...
Hope someone got a better solution than this!
Found a not so nice solution ...
Now I check with the isnull function if the column is empty ... if so I don't display the value ...
This way all expresions show null ... and the row is not displayed...
Hope someone got a better solution than this!