7 Replies Latest reply: Sep 9, 2010 4:56 AM by Chris Hopkins RSS

    Removing duplicate descriptions

    Chris Hopkins

      Hi, i am trying to create a quick app to check if our stores are selling products at the correct price.

      I have loaded in all my data, and i am displaying various fields in a straight table. Basically all of our shops sell cans of Beer / Lager / Cider as single cans or as a 4pk (A discount is offered as a 4pk) i want to see if they are selling the 4 pks at the correct price. i only need to see 1 instance of each brand, i.e FOSTERS, but obviously each store has multiple FOSTERS transactions per day. I am looking for a way to show only the first transaction where qty = 4 for each brand.

      Can anyone help?