Count the number of occurrences without summarizing the data

[HadiElmo]

In excel I can use a count if function with dynamic range to count the occurrence of a value in a variable but not sure how to do it in alteryx. I don't want to use a tool that summarize the data and want to maintain it as it is. 

What I have

Pol no	Prem
AAA111	150
ABB100	500
AAA111	250
AAA111	275
ABC300	175
ADD100	160
ABB100	105
BBB200	93
BDD200	66
ABC300	250

What I want

Pol no	Prem	COUNT
AAA111	150	1
ABB100	500	1
AAA111	250	2
AAA111	275	3
ABC300	175	1
ADD100	160	1
ABB100	105	2
BBB200	93	1
BDD200	66	1
ABC300	250	2

Thanks in advance!

[DataNath]

@HadiElmo if I'm understanding the ask right, is this what you're after?

[Yoshiro_Fujimori · Accepted solution]

@HadiElmo ,

I tried to follow your expected outcome. I hope this helps.

Workflow

[Qiu · Accepted solution]

@HadiElmo 
This is in Cloud, right?

One Tile tool can do the trick, I believe.