5 Replies Latest reply: Jan 19, 2012 2:12 PM by Marcos Herrera RSS

    Set analisys compare vs last year problem

      Di Dear Community

       

      I have this problem with this expression :

       

      sum({<Tipo= {'PyG'},Año = {$(=Max(Año)-1)},Mes={"<=$(vMaxMes2)"}>} MVCO_MTOREN)

       

      I'm using the expression in a Pivot Table With thre dimentions (Superior, Group and Subgroup) to try show the value in the last year and accumulate January to month selected.

       

      The expression works fine when in the Year and Month selected there are values (files in the fact table), some cases there are values (files in the fact table), in the last year of year selected and month selected, but there aren't values (files in the fact table), for the selected year and month.

       

       

      Example

       

      Subgroup Cost value for Aug 2010 --> 1.000

      Subgroup Cost value for Aug 2011 --> There aren't values (files in the fact table),

       

      Year listbox value selected 2011,

      Month listbox selected Aug,

       

      I Test the expression in a Text Object incluying in set analysis the key for value that aren't values for the selected year and month  and works fine