How to make Unique Number?

[#1]

Hi Experts,

i have a request that i have to get the Unique Numbers from given numbers

Sample Given Table:

Id	Months	Names	Visits
0021	JAN	Jack	340
9045	JAN	John	248
4561	JAN	Leslie	3

OUTPUT:

Id	Months	Header 3	Visits	Unique Visits
	JAN	Jack	340	1
	JAN	John	248	1
	JAN	Leslie	3	1

So each Month Unique Visits Increments by 1

E.g JAN = 1

     FEB = 1

     MAR = 1

     APR = 1

and so on, so in a year it should be 12 Visits.

[petter]

AutoNumber is an option

[#3]

Hi,

How can i Utilize it on an Expression. Straight or Pivot Table?

Please supply an Example.

[Peter_Cammaert]

How about =count(DISTINCT Names)?

[#5]

Hi,

Below is my Expression Used:

=sum(aggr(count(DISTINCT SalesDate),CustomerName,SalesDate))

Please Help.

[Anonymous]

use   in script  autonumberhash256(Id,Months,Year) as uniqueId

If it is for only one year need not consider year but if you need for future many years, you need to consider year also.

at front end table   ---> count(uniqueId)

[PrashantSangle]

How do you calculate Visits????

sum(aggr(count(DISTINCT SalesDate),CustomerName,Months,Year))

Regards

[Anonymous]

what unique number you want to show?

[#9]

Hi,

Below should be output:

id	Total Visits	Unique Visits
0023	12	1
454	3	1
887	37	1
069	244	1
009	78	1

For each id i must get unique number regardless how many visits i made in a Month

Below is the Expression i use to get total visits made:

=sum(aggr(count(DISTINCT SalesDate),CustomerCodeName,SalesDate))

[Peter_Cammaert]

So for every Id unique visits is ... 1. Otherwise the Id line would not appear in your table.