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.
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
i don't undrestand very mauch your problem , but ithik if use the month year in set analysis is more simple. you concatenate th emonth and the year and in your expression set analysis you compare the fileds monthyear.