Hello,

I am new to Mondrian, and I need some help with MDX query.

For example:

year 1 id_client: 1,2
year 2 id_client: 2,3
year 3 id_client 1

If I try to do a "distinct-count" aggregator for id_client, I get this result:

year 1 2
year 2 2
year 3 1

How can I calculate only new id_client? I need this result
year 1 2 both clients are new
year 2 1 only client with ID = 3 is new
year 3 0 no new clients