how to write expression

[kunkumnaveen]

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

[sunny_talwar]

Try this

Sum(TOTAL <partt> volumn)

or this

Aggr(NODISTINCT Sum(volumn),partt)

[Anil_Babu_Samineni]

Because, Aggregation work only Group By condition

you can try somthing lke below

aggr(NoDistinct sum(volumn),partt)

[kunkumnaveen]

Hello Sunny ,thanks for quick reply ,y do i am getting total as null

[sunny_talwar · Accepted solution]

Because you don't have an outer aggregation... May be add Sum()

Sum(Aggr(NODISTINCT Sum(volumn),partt)) * ....

[kunkumnaveen]

Sunny ,can u help me how to group the below  column  460,30

[sunny_talwar]

Remove all dimensions except for partt

[kunkumnaveen]

will it not possible by keeping dimensions

[sunny_talwar]

You want to see two rows? which vendor_code should it show for A in the single row is shows for A?

[kunkumnaveen]

what i need to show is a new column at the end

each row                     new _column

                                460-420

                                 460-420

                                  460-560

                                   30-30