AnsweredAssumed Answered

filtering filtered portal

Question asked by rounakjain on Dec 9, 2012
Latest reply on Dec 11, 2012 by philmodjunk

Title

filtering filtered portal

Post

     I have a portal which shows data from a table with unique records.

     The portal has the following fields:

     1. Product Name

     2. Prodcut Size

     3. Product Rate

     I have filtered the portal to show only those records where Product Name = "Item X".

     The product sizes for "Item X" are like:

     1/2 x 3, 1/2 x 4, 1 x 4, 1 x 12, 3/4 x 3, 3/4 x 5

     What I want to see in my portal is

     1/2 x 3 (or 1/2 x 4 whichever comes first based on sorting criteria of my portal)

     1 x 4 (or.............(as mentioned above))

     3/4 x 3 (or.....(as above)

     Thus I want only one record for each unique size "beginning" i.e. 1/2, 3/4, 1 and so on.

Outcomes