Straight table Counting Single variable within Dimensions Query

[mohiahmed]

Hello,

I have set up a straight table and in there I am trying to get a count of from one of the dimensions.  Its called Check Results and trying to get count of Failed Conformance and Failed Compliance.  There is another variable in dimension (Check Result) and don't want to bring that through. Every time I am doing a count it keeps coming back with count of all rather than a single variable.

Please see attached, and if you can give me some pointers that would be truly appreciated.

[sunny_talwar]

May be you need this:

Count({<[Check Result] = {'Failed Conformance', 'Failed Compliance'}>} [Check Result])

[mohiahmed]

Thanks you Sunny, that was very helpful just what I needed.