I need to filter a report based on a condition of report line items being present

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
I have a report of equipment line items by project. I am being asked to filter this report and show only certain equipment types when a piece of equipment is present

So when there is equipment type A, B & C I am being asked to hide B & C from the report but in some cases there is not a Type A but there is a B & C so those will need to be present.

This report is by Divisions so the report groups the equipment by store location and there are multiple store locations per report and one or several of the stores could have this condition.
Photo of Joey Zint

Joey Zint

  • 1,870 Points 1k badge 2x thumb

Posted 1 year ago

  • 0
  • 1
I don't believe I'm understanding the question / use case. It sounds like you're wanting to filter based on something that isn't present? Can you walk through the use case in a little more detail or provide an example layout of the report that you're trying to generate?