Pivot table expression

[stephenedberkg]

Hi

I have attached the screen shot in this case i have only recqty(Final column) for only 2 distributor which i have marked both has recqty0.68 others

has no recqty but i am geting all the values are 0.68.

is there any wrong with data modal?

[varshavig12]

I'm not sure,

But you can try this:

aggr(sum(recqty),Distributor)

[stephenedberkg]

varshavig12

Already i tried but not working

[oscar_ortiz]

Stephen,

You're going to need to supply additional information. 

What dimensions and expressions are you using? 

What relationship do the dimensions and expressions have? 

Are they coming from a single table or multiple tables?

Maybe you can post an example of your data?

Good luck

Oscar

[varshavig12]

Can you post some sample data ?