2 Replies Latest reply: Nov 13, 2012 8:50 AM by a.shafiee RSS

    Price in each row

      Hi friends,

      I want to access to 1,414,921,650 value in each row.

      but only i see it in one row and total row.

      what can i do?

       

      Pivot_02.jpg

        • Re: Price in each row
          Stefan Wühl

          Well, how are we supposed to help here?

          It would really help us to help you if you could tell us the expression you are using, unless you want us to start wild guessing (some other information about your data model etc might also help).

           

          Maybe you do, so I assume you are using an advanced aggregation in your expression (i.e. the aggr() function).

          As I said, just guessing.

           

          Try adding a NODISTINCT qualifier to the aggr() function, like sum(aggr( NODISTINCT sum(FIELD), DIMFIELD1, DIMFIELD2))

           

          Regards,

          Stefan