Creating a new dimension containing the count of a dimension.

[VS2]

Hi, I have a table containing user and units. I would like to create a new column in qlik which contains the count of unit. for example user abc and xyz have unit = 1. so count(unit) for both of them would be 2(as unit = 1 occurs two times).

Can anyone help how can I do it ?

[Taoufiq_Zarra · Accepted solution]

@VS2  maybe like ?

input :

measure :

=count(total <unit>user)

output: