average sales

[sagaraperera]

Dear All

my table include a sales figure month wise. i want a avarage sales figure in a one column. please help.

my script

SALES:

LOAD BCOD,

     CLA_CODE,

     PRD_CODE,

     POLICY_NO,

     REF_NO,

     DATE(floor(MARKETING_DATE)) as  MARKETING_DATE,

     //DATE(monthstart(MARKETING_DATE), 'MM-YYYY') as MonthYear,

     MDATE,

     YEAR,

     MONTH,    

     NAME,

     ME_CODE,

     //TRN_DATE,

     DATE(floor(TRN_DATE)) as  TRN_DATE, 

     TRAN_YEAR,

     TRAN_MONTH,

     POL_PERIOD_FROM,

     SCCOD,

     IF(SCCOD>='SC0','COUNTER')AS CITY_COUNTER,

     CP,

     RS,

     TC,

     GROSSTOT,

     TYPE,

     N_R_NOS1,

     F_NOS2

FROM

G:\qlickviwe\Sales\SALES2012.QVD

(qvd);

[stephenedberkg]

avg(aggr(sum(sales),month))

[MK_QSL]

Which field is showing Sales figure?

You can use something like below

Avg(Aggr(SUM(YourSalesField),MONTH))

[krishna20]

Hi,

Refer this link, It may helps.

Calculate average pr month

[gautik92]

avg(aggr(sum(sales),MonthField))