Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI, i got a sample data like below,
partt component12 plant_code vendor_code volumn unit_price
A 01 xxx aaa 10 12
A 02 yyy bbb 15 12
A 03 zzz ccc 10 16
B - jjj ddd 5 6
i am able to display 35 only in one row ,how to display 35 in remaining two rows as well ,
Expression :aggr(sum(volumn),partt) ....what is wrong with his expression
Thanks
Because you don't have an outer aggregation... May be add Sum()
Sum(Aggr(NODISTINCT Sum(volumn),partt)) * ....
Try this
Sum(TOTAL <partt> volumn)
or this
Aggr(NODISTINCT Sum(volumn),partt)
Because, Aggregation work only Group By condition
you can try somthing lke below
aggr(NoDistinct sum(volumn),partt)
Hello Sunny ,thanks for quick reply ,y do i am getting total as null
Because you don't have an outer aggregation... May be add Sum()
Sum(Aggr(NODISTINCT Sum(volumn),partt)) * ....
Sunny ,can u help me how to group the below column 460,30
Remove all dimensions except for partt
will it not possible by keeping dimensions
You want to see two rows? which vendor_code should it show for A in the single row is shows for A?
what i need to show is a new column at the end
each row new _column
460-420
460-420
460-560
30-30