3 Replies Latest reply: May 6, 2011 3:48 AM by JOAKIM HAGERWALD RSS

    Filtering in expression

    JOAKIM HAGERWALD

      Hello!

       

      I'm trying to filter my data in the expression as example below:

       

      Sum({$< Year = {"2010"}>}ABC)

       

      This works fine. However, when I try to add another filter I just can't seem to get it right... I've tried many variations of bellow:

       

       

      Sum({$< Year = {"2010"}>} and {$< Customer = {"AAA"}>} ABC)

       

      (I want to show only ABC values where the Year is 2010 and Customer is AAA)

       

      Is there any way of doing this? I belive I'm just not using the correct syntax.

       

      Thanks in advance!