2 Replies Latest reply: Nov 26, 2014 12:21 PM by Fernando Tonial RSS

    Set Analysis Exclusions

      Hi all,

       

      I have a case where my dimension is [Month], and my measure is [Sales]. With my expression, I need to track [Sales] according to user's Month selection. For instance, if the user selects 4/2014 and 5/2014, I need to display the sum of [Sales] that happened "before" 4/2014. Right now, I'm using the following:

       

      Sum({$<[Month]= E({<[Month]={"='$(Min([Month]))'"}>})>} [Sales])

       

      But I'm simply getting the whole sum of [Sales] all across my app. Does anyone have some insight into this?

       

      Thanks