How to Add a Counter Depending on a Column Value?
|Product||Progress® Telerik® Reporting|
I would like to add a total count depending on the value that I have in the "Category" field. I need to know how many Category = "A" and how many Category = "B" are there in the data.
You may utilize the
Sum aggregate function, and pass it as an argument either 1 or 0, depending on the value of the field, e.g. 'Category'.
Here is a sample Expression that would return the count of the rows with Category = "A":
= Sum(IIF(Fields.Category = "A", 1, 0)).
The Expression counts each 'A' Category value as 1 and the rest as 0, hence will return the number of A.