I made a bar chart report. I want to eliminate the "number of transactions" if they don't have a certain amount, example <1% or <25 total. When customizing, the "number of transactions" is not a filter selection but all of the "categories are (both initial and dynamic). Any suggestions?
I think that your only hope would be if the categories on which the report is charting are a parent table. If you can summarize that % back up to the Parent and then look that up down again to the children into a field called [Overall % for this category], then you would have that field as a filter on your children to filter those out of they are less than 1%. The Summary field would need to exactly mimic your report filter.