AnsweredAssumed Answered

Portal Filter Records - Unique Only

Question asked by Terri on Nov 5, 2012
Latest reply on Nov 20, 2012 by philmodjunk

Title

Portal Filter Records - Unique Only

Post

     I am hoping to be able to filter a portal record for unique only. 
      
     Here is an example of the records that are in the table that the portal is showing:
      
     Style: #12345
     Color: WHI
     Season: SS
     Season Year: 2013
      
     Style: #12345
     Color: WHI
     Season: FH
     Season Year: 2012
      
     Style: #12345
     Color: BLA
     Season: FH
     Season Year: 2012
      
     The layout I'm using is related to the other table by style number. The portal shows all the colors for that style. But I want WHI to only show up once. I'm not sure which type of calculation I could use to ensure it only shows up once.
      
     Any brainstorming ideas?

Outcomes