Symptom
When the columns of a report definition are summarized by using the COUNT function, the filter option becomes unavailable on these columns in the summarized report.
Explanation
The reported behavior is as per Pega product design. When the columns of a report definition are summarized by applying either of the Out-Of-The-Box (OOTB) functions such as COUNT, AVG, SUM, and so on, the data in these columns are aggregated in the summarized report, where the filter option is missing.
Environment
The issue was reported in the following environments:
- Pega Platform™ 7.1.7 on-premises
- Pega Platform 8.6.2 in Pega Cloud services® 2.21.2
Solution
To filter columns of a summarized report, create a drill-down list from the report.