Is there a way for a report to show you which filter the project fell under

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have a report with numerous filters utilized relating to dates entered into fields.  Is there any way for it to show me which filter caused a project to appear on that report.  So if I have it filtered so that if field A or field B are from the past month it shows up but have it tell me whether it was field A or field B that met the filters needs?

Photo of Data

Data

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Blake Harrison - DataBlender

Blake Harrison - DataBlender, Champion

  • 100 Points 100 badge 2x thumb
I don't think you'd be able to do this with any of the standard settings in a report, but you could create a Formula Text field that you could use to identify if it's field A or Field B that meets the required criteria. You would then be able to use that new Formula field as the Group By in the report and see how those break down.