10 Replies Latest reply: Jul 16, 2013 7:42 AM by Ariel Klien RSS

    Nested problem

    Ariel Klien
      Hello all,
      I need help with the following:
      i have a table like this:
      Object_TypeObject_IDDATE
      AAA101/01/13
      AAA201/01/13
      AAA302/01/13
      AAA205/01/13
      AAA105/01/13
      BBB101/01/13
      BBB201/01/13
      BBB301/01/13
      BBB401/01/13
      BBB402/01/13
      I need to count only the first Object_Type & Object_ID .
      Discard the raw's in bolt.
      If I will use count(Object_Id) in expression and Object_Type and Date in Dimensions I will get:
      Object_TypeDATECount(Object_ID)
      AAA01/01/132
      AAA02/01/131
      AAA05/01/132
      BBB01/01/134
      BBB02/01/131
      I need that the table will be like:
      Object_TypeDATECount
      AAA01/01/132
      AAA02/01/131
      BBB01/01/134
      How can I achieve that?
      BR
      Ariel