i want sum of total instead of avg.

[#1]

hai Guys, i want  sum of total instead of avg..

here i attach that file.

pls send expression for ( OP Column).

[swuehl · Accepted solution]

Hi,

watch out for topic sum of rows in pivot table in the help file.

You probably need something like

=sum(

aggr(

(SUM(IF(SDOC < STARTDATE AND (SPGROUP = 'RAW MATERIAL' OR SPGROUP = 'SEMI FINISHED GOODS'),

(SREC*SWEIGHT-SMIN*SWEIGHT)/1000,0))/2),

PROW,PDESCRIPTION,PRODUCTID)

)

Regards,

Stefan

[#3]

thank u.....