How do I remove data from a report when it's not in the "filters?"

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered
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?

Photo of Jim

Jim

  • 62 Points

Posted 4 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,542 Points 50k badge 2x thumb
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.
Photo of Jim

Jim

  • 62 Points
Say again, please. :)