2 Replies Latest reply: Sep 18, 2013 9:17 AM by Robert Evason RSS

    Nested Set Analysis??

      Hello

       

      Attached is an issue i am trying to resolve and was hoping somebody may have an answer to.

       

      I have two dimensions 'Team' and 'Month' and the following expression;

      =IF(SUM({<Month={3}>}Sales)/SUM({<Month={3}>}Calls)<0.3,NUM(SUM(Sales)/SUM(Calls),'#,###%'))

       

      What i want is if the percentage for 'Month 3' for any 'Team' is below 30% then return the results for those teams for each 'Month'.

       

      i.e. 'Teams 101 and 103' have a % below 30% in 'Month 3' therefore i want to display 'Teams 101 and 103's' results for 'Months 1, 2 and 3' and not display 'Team 102' at all.

       

      Many thanks in advance.