In a straight table, i have 5 customer details as I would like to display in a separate straight table for each client for instance I have tried in the calculated dimension like if([Customer Number] =1,1) but this is not working the result is matching of 1 becomes 0 and the rest become -1.
Could you please advise how to show the data only [Customer Number] =1.
