13 Replies Latest reply: May 13, 2013 10:59 AM by Sukhwant Matharoo RSS

    expression query

    Sukhwant Matharoo

      hi all,


      i have a table


      id     category     value         cat1    

      a        abc              10          abc

      a         xxx          20             abc      

      a          yyy          30            abc       

      a          ddd          35            abc  



      i have a straight table and working on expression:


      dimension          expression:sum(value)               expression:sum(value)-sum({<cat1={category}>}value)

      id                         total                                             total-cat1

      a                            95                                                  85



      third column is not giving me 95-10 as value it gives me 95 in third column as well.


      please advise if syntax in 3 expression is correct?


      thanks in advance