1 Reply Latest reply: Jan 14, 2010 9:37 AM by Anita Fuchten RSS

    dimension overruled by set analys in expression???

    Anita Fuchten

      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