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

    Filtering in expression



      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!