Value from an unselected filter

[Anonymous]

Hi everybody,

i have a DB table with the following fields:

IDPARK , YEAR, MONTH, VALUE

1           ,2011     ,1          ,4234

1           ,2011     ,2          ,3453

1           ,2011     ,3          ,45745

1           ,2013     ,7          ,768

1           ,2013     ,8          ,989

1           ,2013     ,9          ,34

in a PIVOT table i use IDPARK as Dimension and  VALUE as Expression.

If i select a YEAR and a MONTH from a filter everything works good and the table show the right value; but i would like that when i do not select a filter, the table show me the VALUE linked to the max(makedate(YEAR,MONTH)) . In this case September 2013.

Or if i select from a filter YEAR = 2011  show me the value of March 2011 .

Is it possible?

Thanks

[Carlos_Reyes]

You can do that, or you can add a Date and/or a MonthYear field and still use Set Analysis.

Review the attached.