This content has been marked as final. Show 6 replies
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?