kmizuno
12 minutes agoQrew Member
How to group a report by individual values in a Multi-select Text field?
I have a Multi-select Text field on my Projects table called Project Products. A project can have multiple products, for example:
Product A; Product B; Product C
I’m trying to build a report that groups/counts by each individual product, but when I group by the multi-select field, Quickbase groups by the entire combination of selected values instead.
For example, I’m getting groups like:
Product A; Product B
Product A
Product B; Product C
Instead, I want the report to display:
Product A — 2 projects
Product B — 2 projects
Product C — 1 project
Is there a way to “explode” or separate the values from a Multi-select Text field so each individual product can be grouped and counted within one report?