Forum Discussion
Paginated Report - Filtered Group Totals
Hi there! I have a paginated report for which I am having trouble filtering group totals. I have a table with the blue rows below which filter out "Corporate" and "Comp" which are totaled separately ...
Hi reports123 ,
When setting up your filters, especially for totals, ensure you're using aggregate functions that align with the filtering criteria. This might require adjusting your expressions slightly to ensure they aggregate correctly for the totals.
Below is the official link will help you:
Another approach could involve using parameters in your report to control the visibility of certain groups or totals based on user selection. This can sometimes offer a more dynamic way to manage what data is included in totals without directly modifying the dataset or expressions.
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.