Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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

View solution in original post

2 Replies
swuehl
MVP
MVP

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

Not applicable
Author

yuhuuuuuuuuuuuuuuuu

Thats right.

tnx so much