Report - Need to filter Data values on x axis

Question

I have a report that shows number of leads on the x axis for the value of Y (which in this case is 'indication'). I can't figure out how to hide anything with a value of 0.

Does this need to be a report formula, or should I be able to do this from the filter? Either way, it seems like there must be a simple solution and so far I haven't figured it out.------------------------------Mathew Crist------------------------------

MarkShnierYou · Answer

The only way to do this is to have a summary field on the indication table for the number of records. Then you would be able to look that up down to the details table and filter on that.

However the problem is going to be that if there are other filters on the report or time periods involved in the summary field is not going to recognize that. So currently it's not that easy to do.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community