How to add expression in straight table without duplicates?

[#1]

Hi,

I have a column CustomerId with duplicates. I need to add this column as expression in straight table without duplicates. can anyone please suggest how to add expression without duplicates.

Thanks.

[Anonymous]

It is possible.

After adding the CustomerID what do you want to do in straight table?

[#3]

Thanks. I have to add multiple columns (name,Id,progress) in the table as dimensions. but the expression is Count(Distinct(IF(ISNULL(DateIclosed),ID)))

here Id have unique values only Customerid have duplicates. But I need both ID and Customerid to add in table.

Please help.

[sebastiandperei]

Hi, could you send a reduced copy?

[#5]

Thanks. Please see attached.

[Anonymous]

I checked your data.

Lets take one example.

The customer ID 39 has two different IDs(11108,26218).

In this scenario how do you want to see the output?

[#7]

Thanks. I want to see the straight table should show only one CustomerID with two IDs(11108,26218).

i,e the CustomerID should populate only once in straight table.

Is it possible?

[#8]

Try using Only (DISTINCT [Customer ID])

[sebastiandperei]

For CustomerID=39, you have ID=26218 and ID=11108 Which one you want to see? They have different values of DataClose, DataEnter and Name field values.

Your expression will count the "ID" that have not null in "DataClosed" field, so if you put the "ID" dimmention, obviously, the number of ID for each ID will always return 1.

Remember: The expression will calculate for each combination of the different dimmentions. What exactly do you need?

[#10]

Thanks. It is showing error