Need to create a count variable according to the different fields and that count value should increa

[Shinooj_M]

Hi All,

 I have some sample data here.

I WANT TO CREATE A INCREMENT COUNT VARIABLE .

USER RAM VISITS ABC CATEGORY AND XYZ SUB CATEGORY , SO COUNT VARIABLE IS 1

AND NEXT TIME IF THE SAME USER VISITS THE SAME CATEGORY AND SUBCATEGORY THE COUNT VARIABLE SHOULD INCREASE  TO 2 AND SO AND SO. CAN ANYONE HELP ME TO GET THAT DONE .

NOTE : THE USERS ARE NOT STATIC , THE USERS WILL BE CHANGE EVERYDAY .

User ID	Category	Sub Category	Updated	CREATED
RAM	ABC	XYZ	2020-10-28 12:31:18	2020-09-28 10:31:18
RAM	ABC	XYZ	2020-10-29 10:40:32	2020-10-29 9:20:32
RAM	ABC	LMN	2020-11-02 18:02:00	2020-10-02 12:52:00
ADAM	ABC	XYZ	2020-10-30 08:56:05	2020-08-30 18:56:05
ADAM	ABC	LMN	2020-11-02 12:00:56	2020-11-02 12:00:56

Thankfully,

Shinooj 

[Taoufiq_Zarra]

@Shinooj_M  can you share the expected output from this sample ?

[Shinooj_M]

Please find the expected output below .

want to create a counter variable which gives how many times the user visits the same category an subcategory .

• User RAM Visits Category EDF and Subcategory LMN is 1 time.
• User RAM Visits Category ABC and Subcategory PQR is 2 times
• User ADAM Visits Category ABC and Subcategory XYZ is 3 time's.
• User ADAM Visits Category EDF and Subcategory LMN is 2 time.
• User RAM Visits Category ABC and Subcategory XYZ is 2 times.

Please find the sample data below

[Shinooj_M]

Any Update . Is this possible..Please respond

[kfoudhaily]

hello,

load

User, 
[ID Category],
[Sub Category],
Updated,
CREATED,
autonumber (User&[ID Category]&[Sub Category]) as [you var]
from ...

please don't forget to mark accepted if response is ok for you.

regards,