How to use count function

[#1]

Hi All,

I have the following case:

Table structure:

Category

A

A

B

I want to get the row count whose category is A, it results will be 2.

How can I do?

Thanks.

Isaac Li

[#2]

Hi,

1. If you are using a straight table then just put Category in dimension and in expression specify

count(Category)

2. If you are using a text object then you can write the following expression

count(if(Category='A',Category))

May be this helps you.

Thanks & Best Regards

Kuldeep Tak