Forum Discussion

BarbaraAlvarez1's avatar
BarbaraAlvarez1
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's avatar
BarbaraAlvarez1
Qrew Member
3 years ago
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
------------------------------
BarbaraAlvarez1's avatar
BarbaraAlvarez1
Qrew Member
3 years ago
I could create more than one summary report to include the group by(s) that I'm missing.     The end results of this report(s)  -  I will export to a spreadsheet and use as data to populate another table.  So I think this will solve the problem.    You can still provide other suggestions!    Thank you

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