dimension if statement

[#1]

Hi,

I am trying to create a straight table using one dimension to show to total count. This dimension has two types of values 'Auto' and 'Manual'.

How and where can I limit this table to show me the total count of the 'Auto' value only?

Or if I should be using a straight table for one dimension what should I use for the above.

[trdandamudi]

I created a sample for you and please see the attached. Hope this helps...

[#3]

thanks for the reply.

I that the exact syntax required? I tried it (using my own var names) and didn't work as there was an error in the expression box. Also, is it not the textcount function rather than the count function required for the value = 'Auto'?

[Anil_Babu_Samineni]

T P

Would you share the Expression you have tried ver there

[#5]

So I am trying to give a simple count of how many times the Matched column as the value 'Auto' only. I don't want to include 'Manual' at all in the result (seen in yellow and it doesn't have to be aligned like the way I made it in excel)

What's the best sheet object to use?

[#6]

this is what I have tried which Is wrong.

count({<matched={'Auto'}>})

[Anil_Babu_Samineni]

You may try this

Count({<matched = {'Auto'}>}matched)

[varshavig12]

May be like this,

count({<matched={'Auto'}>}matched)

[#9]

In expresion try the below.

Count ({<matched={'Auto'}>}matched)

[susovan]

You can also try this attachment,