Summary report question
I need to create a report that will only show each customer once along with the unique values in several columns. What is the best way to accomplish this? ------------------------------ Paul Pete...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendHave you tried a Summary Report Type and then group by the customer name and also group by those unique value fields?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- I tried that, but the result was not what the user wants. It generated a report with the Customer name, the first time in standard text and grey in the subsequent rows. They only want the customer to appear once in the report. Would it work if I tried creating a combined text summary field for the fields where they want the unique values for each customer?
------------------------------
Paul Peterson
------------------------------- MarkShnier__YouIt would be helpful if you could post a screenshot of what you want the report to look like by marking up two customers in Excel
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- MarkShnier__YouBut your solution with combined text fields would work and if you like there is a sample formula to convert a combined text summary field with that "pill" appearance to say a vertical list of regular text.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
