Forum Discussion

BenjaminBrooks's avatar
BenjaminBrooks
Qrew Trainee
5 years ago

Dynamic Filter in Report Based on Summary Field

Hello,

I have created a summary field based on a table to table relationship based on a combined text function and I would like to use it on a report that I would like to create but it is not allowing me to dynamic filter based on these summary fields. how do I go about doing this?

------------------------------
Benjamin Brooks
------------------------------
  • If you have a Combined Text Summary field and want to use it as a Dynamic Filter, then make a new field  of type Formula Multi Select Text (which will be eligible as a Dynamic Filter) and the formula is

    Split(ToText([My Combined Text Summary field]))

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • BenjaminBrooks's avatar
      BenjaminBrooks
      Qrew Trainee
      Thank you!

      ------------------------------
      Benjamin Brooks
      ------------------------------