7 Replies Latest reply: Oct 23, 2013 6:28 PM by OBD RSS

    Filter measure column for current year

    OBD

      Hi,

       

      I'm stuck up with issue, we have a report from three tables D1, D2 and F1. In which D1 is time dimension. Now we have report from D2 and F1 with measures, and the report is placed in Dashboard which is having year prompt.

       

      F1 is joined with D2 and D1 Time dimension as well, the requirement is in the report one of the measure column say X should always show the values for current year, while others will show according to prompt values.. In short I want to display one of the measure column for current year, even though the user selects the prompt value for year earlier to it the values should not change.

       

      Please let me know, how to achieve this.

       

      Thanks in advance