In my Commerce Order settings I have created a custom select list field with the following Allowed values.
Allowed values list
1|01/03/2013
2|02/03/2013
3|03/03/2013
4|04/03/2013
5|05/03/2013
Currently I can choose a date from a select list and that filters all sold products and gives me the result for that date. I am able to separately filter all products sold for each date using views but is there a way I can list the results of each date separately in a block?
Is this possible or do I have to add the field for each date and set the operator Is equal to the date for each date in my select list?
I would like the output to be something like this.
Event Date Sales
01/03/2013 Total: 210
02/03/2013 Total: 150
03/03/2013 Total: 621
04/03/2013 Total: 500
05/03/2013 Total: 142