8 Replies Latest reply: Jun 2, 2015 3:16 PM by Simon Brulotte RSS

    Full accumulation: having dimensions reflecting selection but expression that don't

    Simon Brulotte

      Hi,

      I want to show a graph/chart with a drill down from Year to month. Our year end starts june 1st.

      periods 2015-05 to 2016-01 data is shown here:

       

      Full accumulation.png

      With one dimension, I get my full accumulation

      Full accumulation2.png

       

      If I do a selection on the year 2016, I get only june but get 21 920.54$ instead of 443 168.22$.

      I want a full accumulation so I do a set analysis to exclude the selection of the year. I get 443 168.22$ but all the months of 2015.

       

       

      How do I get just june, 443 168.22$ ?