Different scenario

[#1]

Hi Team,

I have following kind of data.

Emp	Issue	Key	Pkey
Julee	LDT	a113	a112
John	Worked	a112

I want count against Emp ( dimension: Emp). It should be counted when Key is exist in Pkey when issue LDT only on name of john.

[Anil_Babu_Samineni]

Would i know expected output from given data

[#3]

Emp Issues ( Count)

Julee 0

John 1

[Anil_Babu_Samineni]

May be this expression

Count(DISTINCT {<Pkey = {''}>} Key)

[vishsaggi]

May be this? Not sure if that works with more data. Just let us know.

LOAD *, IF(Key = Previous(Pkey), 1, 0) AS KeyCnt INLINE [

Emp, Issue, Key, Pkey,

Julee, LDT, a113, a112

John, Worked, a112

];

Use straight table and

Dim: Emp

Expr: Keycnt

[#6]

No.

I mean when pkey is exist in key then it should counted 1 on name who worked on that. Should not counted who Lost.

2. It's not exactly above or below the record. It can be any line @vishwanath

[Anil_Babu_Samineni]

Try this? Count({<Key=P(Pkey)>} Pkey)