Show all values from a selection

[#1]

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!

[rustyfishbones]

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

like

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

Regards

Alan