Support Article
No filter for the column in summarized reports
SA-21129
Summary
When a column in a report definition is summarized, there is no filter option to filter the columns.
Error Messages
Not applicable.
Steps to Reproduce
1. Create a multi-column report definition.
2. Summarize one of the columns by selecting the COUNT summarize function.
3. Run the report definition.
Observe there is no filter (icon) to summarize the columns.
Root Cause
The observed behavior is not a bug, but an expected design behavior.
Whenever, a column is summarized, with say any of the OOTB functions COUNT(), COUNT DISTINCT(), SUM(), AVG(), MAX(), or MIN(), the data in that column is aggregated and the report is presented in the summarized view.
Resolution
Whenever, a column is summarized, with say any of the OOTB functions COUNT(), COUNT DISTINCT(), SUM(), AVG(), MAX(), or MIN(), the data in that column is aggregated and the report is presented in the summarized view, and therefore, no filter is applicable.
Published March 18, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.