group results

  • 1
  • Question
  • Updated 4 years ago
  • Answered
If I have a 1000 items and most are the same. How do I only show 1 unique line item.  So, instead of 1000 items it will show 23 unique lines?
Photo of Bill Fox

Bill Fox

  • 8,870 Points 5k badge 2x thumb

Posted 4 years ago

  • 1
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,828 Points 20k badge 2x thumb
You need to make an aggregate model. 

Check out this tutorial:

You will not be able to group on your concatenated formula field - but you will be able to group by zip code. 

All fields you want to show on your table will have to be in the grouping section.  

Finally:  If all your fields on the table are on the parent (and grandparent) objects,  why not make your model on the parent objects?