10 Replies Latest reply: Mar 20, 2014 11:32 AM by Carlos Reyes RSS

    Value from an unselected filter

    Luca V

      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