Enters into first If condition every time in expression even there is no data?

[jagannalla]

Hi,

I want to see in striaght table as below image.

- I tried like this first i had taken Id as dimension and in expression as =if(Count({<Defect ={"A"}>}ID) >0,if(Count({<Single = {"Fail"}>}ID) >0,'Fail',if(Count({<Single = {"Pass"}>}ID) >0,'Pass',if(Count(if(IsNull(Single),0)) >0,'null'))),'-')

- I don't know where i'm doing wrong can anyone help me.

For your reference i'm attaching my qve file.

[kaushiknsolanki]

Hi,

     Follow below steps to achieve what you want.

     Create a pivot table with dimension as ID and Defect.

     Now add expression as

     if(Single = '','',if(Single = 'Fail','Fail','Pass'))

     Click Finish/Ok

     Now drag the Defect Dimension over the Expression.

Regards,

Kaushik Solanki

[jagannalla]

Thanks for your response...

But the think is in my real time requirement. I've two dimensions and different number of expressions say for example Min(x),Max(y)......etc and now i want to include the above post conditon also here....

[kaushiknsolanki]

Hi,

    Try this in your real time environment. According to me it should work.

Regards,

Kaushik Solanki

[jagannalla]

Ya i tried in real time environment. But it's not working there also how come it works here without working in small example