Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Cuold you provide the source tables?
Could you please provide any sample data? how exactly your source tables look like???
Excel document in attachments