Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

New Computed Column

Hey, I'm trying to add a new computed column, that will help me to indicate DISTINCT CustID. For the example: the new coulmn will bring me "1" on lines 1, 2 and 5. if ill sum it up, ill get 3 uniqe...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Anonymous  - You could do the following steps:

    1. Order by Customer.

    2. Add an index column starting from 0, and another starting from 1.

    3. Merge the table with itself, joining the one index column to the other. This way, you can retrieve the previous customer.

    4. Add a Custom Column that returns 0 if the current and previous customers are the same, otherwise 1.

     

    Using an Excel formula (if the source is a spreadsheet) is easier:

    1. Order by Customer.

    2. Add a new column, with the following formula (Assumes that CustomerID is in Column A):

    =IF(A2=A1,0,1)

    Hope this helps,

    Nathan

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous  - You could do the following steps:

1. Order by Customer.

2. Add an index column starting from 0, and another starting from 1.

3. Merge the table with itself, joining the one index column to the other. This way, you can retrieve the previous customer.

4. Add a Custom Column that returns 0 if the current and previous customers are the same, otherwise 1.

 

Using an Excel formula (if the source is a spreadsheet) is easier:

1. Order by Customer.

2. Add a new column, with the following formula (Assumes that CustomerID is in Column A):

=IF(A2=A1,0,1)

Hope this helps,

Nathan

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Anonymous wrote:

Anonymous  - You could do the following steps:

1. Order by Customer.

2. Add an index column starting from 0, and another starting from 1.

3. Merge the table with itself, joining the one index column to the other. This way, you can retrieve the previous customer.

4. Add a Custom Column that returns 0 if the current and previous customers are the same, otherwise 1.

 

Using an Excel formula (if the source is a spreadsheet) is easier:

1. Order by Customer.

2. Add a new column, with the following formula (Assumes that CustomerID is in Column A):

=IF(A2=A1,0,1)

Hope this helps,

Nathan

Finally succeed, Thanks so much!