I have the same column in 3 pivot tables in one report. When I choose that column as a filter prompt
and add a value, only the first pivot table reacts to the filter prompt. The other 2 pivot tables ignore the
Any ideas? Thanks.
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?
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.