3 Replies Latest reply: Feb 14, 2013 9:49 AM by jouni.kirjavainen RSS

    How can I count rows with column values selected from a another list

      I have created a list containing years and another containing months. Excel containing three different date columns.

      When I select a year or a month (or both) from a list report has to count number rows found for those 3 columns.

       

      Data (DD.MM.YYYY):

      Id     |     Column1     |     Column2     |     Column3

      ---------------------------------------------------------------------------

      1          01.01.2013        02.02.2013       03.01.2013

      2          01.01.2013        01.02.2013       03.02.2013

       

      Situation1:

      When I select a year (2013) > report shows value 2 for all of those fields.

      Situation2:

      When I select a month (02=february) > report shows value 2 only for col2 and 1 for col3 fields.

      Situation3:

      When I select month (01=january) and year (2013) > report shows value 2 for col1 and 1 for col3 fields.