9 Replies Latest reply: Aug 8, 2011 6:19 AM by Sunil Chauhan RSS

    Need help with this set statement!!


      Hello,

       

      I have a pretty simple table structure as shown below and I am trying to create a bar chart which would show the Amount difference.

      Table1
      CatCode
      Region
      CostType
      ProductGroup
      LocationCode
      Month
      Amount

       

      Expr which I am using is : Sum({$<CatCode={1},Transport Costs={'Normal Freight'}>}Amount)-Sum({$<CatCode={2},Transport Costs={'Normal Freight'}>}Amount)

       

      My cat code is nothing but 1 for Budget and 2 for Actual.

       

      However, I cannot get this working. Any help is greatly appreciated.

       

      Thanks