7 Replies Latest reply: Feb 16, 2012 7:10 AM by John O'Mahoney RSS

    Set analysis not retaining total

      Hi all


      I have a number of properties and can create a percentage of current selection / total properties




      I also have a bookmark that filters the total properties into a specific group and I want to work out the percentage based on this bookmark




      However, when I apply a filter to the data the sum({$*BM05}PropertyIDCounter) also reduces



      How do I apply the {1} effect in the first expression that retains the full count of the bookmark regardless of subsequent applied filters


      Thanks in advance