Distinct count of dimension required

[Ravi_Nagmal]

Hi All,

Please help me, how can i achieve below result in front end table.

Client ID	Result required
ABCDE	1
ABCDE	0
ABCDE	0
ABCDE	0
ABCDE	0
ABCDE	0
ABCDE	0
BDSGE	1
BDSGE	0
HHDES	1

[vincent_ardiet_]

With no more informations about your datamodel, this is hard to answer.
By default, you will be able to obtain this one below, but else, you will need to use other fields to distinguish each [Client ID], like an order number. But else, what is the point to show the data like you are requesting? 

Client ID	Result required
ABCDE	1
BDSGE	1
HHDES	1

[Aditya_Chitale · Accepted solution]

Try:

=Count(Aggr(count(ClientID),ClientID))

Regards,

Aditya

[Ahidhar]

try this

if(ClientID=above(ClientID),0,1)

create one row identifier in script like Rowno() as rowno