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

    Nested Set Analysis??

    Robert Evason



      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;



      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.