1 Reply Latest reply: Aug 22, 2011 4:40 PM by Marc Livingston RSS

    Need to use set analysis to limit dimension

      Currently this is the expression I am using.

       

       

      =((if(caploaddate=if(GetFieldSelections([Load Date])='Today',today(),If(GetFieldSelections([Load Date])='Tomorrow',today()+1,if(GetFieldSelections([Load Date])='Day After Tomorrow',today()+2,if(GetFieldSelections([Load Date])='Three Days',today()+3,if(GetFieldSelections([Load Date])='4 Days',today()+4))))),cap)))
      

       

      Currently this is changing when other selections are made. How would I go about telling the dimension to only look at the field [Load Date]?

       

      I want the chart to only display based on an inline table that I have set to always 1 selected. Hence the long code, where I do not want it to affect other data.