4 Replies Latest reply on Apr 8, 2015 7:25 AM by philmodjunk

    Create a list of unique items from many rows of same data

    Stu412

      Title

      Create a list of unique items from many rows of same data

      Post

      Hi there

      I have data which is set out in the format below:

      Year | Total

      2011 | 1000

      2011 | 2000

      2011 | 2050

      2012 | 1000

      2012 | 1500

      There are many rows per year, and in turn, many years.  

      What I am looking to achieve is a report which would show one result per year, something like:

      Customer | Year2011 | Year 2012 | Year 2013

      Bob         | Yes         | Yes          | No

      Jill           | Yes         | Yes          | Yes

      This would probably be a list layout, but I'm unsure how I get the 'Yes' and 'No' to represent at least one row per year from the source table.

      Any help appreciated, thanks