7 Replies Latest reply: Aug 24, 2012 12:56 PM by brandon breitling RSS

    Want to look at multiple months rather than only current selected for dimension

    brandon breitling

      Hi Community,

       

      I have an expression that doesn't seem to work with my months dimension.  It will only display the value when a single month is selected.  How could I make a chart where multiple months values for this expression are shown?

       

      =SUM(AGGR(count({(<terminationdate = {">=$(=only(MonEnd3))"},

      employmentdate ={"<=$(=only(MonEnd3))"}>)+(<terminationdate = {'-693593'},

      employmentdate ={"<=$(=only(MonEnd3))"}>)-<terminationdate = {'-693593'},

      employmentdate ={'-693593'}>}

      distinct PRMNAM),PRMDDP))