Nested Table -count only First Value

[ariel_klien]

Hello all,

I need help with the following:

i have a table like this:

Object_Type	Object_ID	DATE
AAA	1	01/01/13
AAA	2	01/01/13
AAA	3	02/01/13
AAA	2	05/01/13
AAA	1	05/01/13
BBB	1	01/01/13
BBB	2	01/01/13
BBB	3	01/01/13
BBB	4	01/01/13
BBB	4	02/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_Type	DATE	Count(Object_ID)
AAA	01/01/13	2
AAA	02/01/13	1
AAA	05/01/13	2
BBB	01/01/13	4
BBB	02/01/13	1

I need that the table will be like:

Object_Type	DATE	Count
AAA	01/01/13	2
AAA	02/01/13	1
BBB	01/01/13	4

How can I achieve that?

BR

Ariel

[Gysbert_Wassenaar · Accepted solution]

See attached qvw

[ariel_klien]

Hi Gysbert.

As usually working fine!!

Thanks a lot.

Ariel