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