scenario

[#1]

hi guys,

can u suggest on below?

Input
TicketNumber	ID	TYPE
100	1	A
100	2	B
100	3	C
100	4	B
100	5	E
200	1	B
200	2	A
200	3	E
300	1	A
300	2	A
300	3	E
Output
300	1	A
300	2	A
300	3	E
Note: Ticketnumber consider for Type (A and E) only.

[sunny_talwar]

May be add ID as dimension

1) Max({<Type = {'A', 'E'}>}TicketNumber)

2) FirstSortedValue({<Type = {'A', 'E'}>} TYPE, -TicketNumber)

[satishkurra]

Create a calculated dimension as

=Aggr(Only({<Type={'A','E'}>}Type),TicketNumber)

[satishkurra]

Sunny out of curiosity, will the below expression works in this scenario?

[sunny_talwar]

I am not entirely sure what is the exact requirement, but it looks like going in the right direction

[#6]

hi,thanks for kind response.

1) Max({<Type = {'A', 'E'}>}TicketNumber) -- given all the 3 ticket numbers

2) FirstSortedValue({<Type = {'A', 'E'}>} TYPE, -TicketNumber) --- not given any results.

any help?

[#7]

hi,

this expression not given any results.

any help?

[#8]

hi,

ticket number 100 went through multiple types in cluding A&E  but 300 went through only A and E,so i need to consider that one only.

[#9]

Is't possible to implement or not?

any idea guys,Gysbert,Swuehl,Sunny,Jagan?

thanks