This content has been marked as final. Show 6 replies
What do you mean by "filter prompt"? Within that first pivot table, are you making that field a Pivot Table Prompt? If so, that's the expected behavior... that prompt will only change the first pivot table view.
Thanks for your reply. I mean by Filter Prompt just a filter for the whole report, not just the first
pivot table. And in fact I think you are right - in that the 2nd and 3rd pivot tables reflect the changes in
the 1st pivot table that this filter value has brought.
What's happened now is a slight different issue - that the grand total of all 3 pivot tables is ignoring this
filter value. The filter is based on a distinct count of a numeric field (job_id), called 'Total Jobs'. The filter value
was '>= 9'. So only rows where the total jobs was equal to or more than 9 should be shown. This
happened correctly for the pivot table rows. But the Grand Total on that pivot table was still showing
the previous total. Would you know why?
Try this... Within each of the pivot tables, edit the Aggregation Rule, and uncheck the "Report-Based Total" option at the bottom.
I am not sure if the problem is solved or not, if not you can try putting the aggregate rule as sum within each pivot for the measure which is used for grand total.
Thanks for your reply. Would you know what I set the Aggregation rule to, as I tried a few and it didn't work
for all the columns.
Thanks very much for your reply. I did try Sum for the Aggregation rule but it
didn't work for all the columns across the Grand Total line. They were all just summing numbers.
No averages, or percentages were summed.