Show all values from a selection

Fri, 20 Dec 2013 15:00:56 GMT

Hi all,

I would like to display all values in a table from my selection.

These are my data:

MonthYear, Prod, value

05/2011, Prod1, 0

06/2011, Prod2, 0

07/2011 ,Prod3, 2

08/2011, Prod4, 0

09/2011, Prod5, 0

10/2011, Prod6, 5

11/2011, Prod7, 0

12/2011, Prod8, 1

01/2012, Prod9, 0

02/2012, Prod10, 1

I would like to have this table if I select 2012 in my filter Year for example:

MonthYear, Prod, value

01/2012, Prod9, 0

02/2012, Prod10, 1

but I have this:

MonthYear, Prod, value

02/2012, Prod10, 1

Thanks in advance for your help!

Re: Show all values from a selection

rustyfishbones — Fri, 20 Dec 2013 15:06:11 GMT

Hi Claire,

I think you have an issue with how your date has been formatted

check your date formats are all ok and then try again

DATE([effective-date],'DD/MM/YYYY') AS Date

Regards

Alan