AND function?

[jim_chan]

Hi guys,

I have a script to write.

OK. I have 2 columns Customer ID(001,002) and Change(A,B).

I would like to see records of Customer ID which have change the "change", at below, Customer ID 'A' as made a change from A to B.

Date	Customer ID	Change
01/01/2016	A	A
02/01/2016	A	B
01/01/2016	B	B

So, i created a calculated dimension - if(change = 'A' AND change = 'B',Customer_ID). It is not working,.......

[kristof_j]

and something like

=if(aggr(Concat( DISTINCT Change, '|', Date), [Customer ID]) = 'A|B', [Customer ID] ,)

This will give you customer A.

[tamilarasu]

Have a look at the attachment.

[jim_chan]

Thanks. But i only want a specific pivot table to have such requirements. If i am using the sample that you gave, it would affect the data model.

[jim_chan]

Hello Tamil,

Quite close, thanks! can i max() something else? it suppose to be able to show the day 7(before change), and 8(changed) as well. but if i took out the Day dimension and use the caluclated, then i got the Max Day. which is 8.

Rgds,

jim

[tamilarasu]

Fine. I have attached a qvw file. Please check and let me know.

[jim_chan]

bro. this one worked fine as i requested.

[tamilarasu · Accepted solution]

Great Jim. If you got the answer, please close the thread.