Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
yuhuuuuuuuuuuuuuuuu
Thats right.
tnx so much