8 Replies Latest reply: Jun 5, 2013 2:21 PM by Emily Eddings RSS

    Sum and Aggr Set Analysis Question

      Hi everyone,

       

      I am relatively new to set analysis and have a quick question.  I have a variable that I am trying to display disregarding the current selection. 

       

      I have the following formula:

       

      sum({1}aggr($(Total_Win_Index), [Search ISO Week End Date])) where $(Total_Win_Index) is my variable.

       

      This displays the correct result for the week selected, and nothing for all other weeks.  I would expect it to display everything and disregard the current selection.

       

      Can someone please advise?

       

      Thank you!

      Emily