Forum Discussion

Qrew Member

3 years ago

Return only one occurrence into a table report from multiple occurrences in a table.

I have a table that has, for simplicity, a client name, related agency, related product and price. One client can have many related agencies, and the agencies may have 1 to 5 products (all 5 are t...

BarbaraAlvarez1

Qrew Member

I didn't think of that! The summary report gives me exactly the results what I want, BUT, it is only allowing be to include 5 'then by'. I need to include about 4 more more 'Then By' in my Group By. Possible?

------------------------------
Barbara Alvarez
------------------------------

MarkShnier__You

Qrew Legend

3 years ago

Ah right, the limit is 6 group bys. The only other option is to make a few concatenated fields to join two or more text fields together. Would that work?

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------