4 Replies Latest reply: Feb 27, 2013 4:24 AM by Dwi Sulistiyo RSS

    Rolling 12 Month with dynamic dimension selections

      Hi all,

       

      I have an issue in set analysis for rolling 12 month calculations (please see attached qvw).

      My calculations is already correct for all region, but when i selected one region the value is not changes because i'm using 1=static in my set analysis because if i remove or change it to $ then the expression will only calculated for current sales only.

      So..how i can achieved rolling 12 month calculations that can also move with others selected dimension (needed urgent).

       

      Thank you..