Multirow formula issue

[Nastya]

Hi! I have the following problem:

I need to create ID for positions like in the following example:

Position	ID
A	1
A	1
A	1
B	2
B	2
C	3

I tried to use multirow formula 

IF [Row-1:Position]=[Position] THEN [Counter_id] = [Row-1:Counter_id] ELSE [Counter_id] = [Row-1:Counter_id] + 1 ENDIF

Where column [Counter_id] is initially a column with 1 in every row. But result column shows wrong answer - there are only 0 and -1 values

Thanks for any help

[Thableaus]

Hi @Nastya 

Use Tile Tool with Unique Value method:

Unique Value being your Position field.

The Tile_Num field would be your ID now.

Cheers,

[patrick_digan]

@Nastya  Very close! I would try something like this:

IF [Row-1:Position]=[Position] THEN [Row-1:Counter_id] ELSE [Row-1:Counter_id] + 1 ENDIF

[ankit_mandal]

Hi Nastya, 

You can create a column whose value is 1 and then create the ID column by creating a running total of the same column and grouping by the "Position" column . 

Thanks, 

Ankit.