Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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....
Hi,
Try this in your real time environment. According to me it should work.
Regards,
Kaushik Solanki
Ya i tried in real time environment. But it's not working there also how come it works here without working in small example