CUMULATIVE

[sagaraperera]

Dear all

please advise me as how to get the cumulative automatic updated when the month table is selected Eg; When the seletion month is may the cumulative figure should total up the value of jan.feb,mar,april and may.

i give below the my script that was above by me in this connection.

CrossTable(DESCRIPTION, BUDGET, 6)

LOAD BCOD,

     MONTH,

     YEAR,

     MONTH2,

     CLA_CODE,

     MONM,

     GROSS_PREMIUM,

     SRCC_PREMIUM,

     REINSURANCE_FUND,

     FOREIGN_COMPANIES,

     CEEDED_PREMIUM,

     NRP,

     UPR_CHARGE,

     NEP,

     SRCC_TC_COMMISSION,

     FOREIGN_CO_COMMISSION,

     COMMISSION_INCOME,

     NET_REVENUE,

     GROSS_CLAIMS,

     CLAIMS_RES_FUND,

     EXGRATIA_CLIMS_RES_FUND,

     CLAIMS_PROCESSING_EXPENSES,

     LEGAL_FEES,

     RI_RECOVERIES_RI_FUND,

     RI_RECOVERIES_SRCC_TC,

     RI_RECOVERIES_FOREIGN,

     SALVAGE_RECOVERIES,

     NET_CLAIMS,

     COMMISSION_EXPENSES,

     PRODUCTION_BONUS,

     DAC_CHARGE,

     ACQUISITION_COST,

     GROSS_PROFIT,

     STAFF_EXPENSES,

     ADMIN_EXPENSES,

     SELLING_EXPENSES,

     FINANCIAL_EXPENSES,

     DEPRICIATION_EXPENSES,

     MANAGEMENT_EXPENSES,

     INV_INCOME_EXT,

     INV_INCOME_INT,

     OTHER_INCOME_EXT,

     OTHER_INCOME_INT,

     INV_OTHER_INCOME,

     NET_PROFIT

FROM

[..\..\..\qlickviwe\P&L\P&LBUDDATA2011_2014.QVD]

(qvd);

Directory;

CrossTable(DESCRIPTION, BUDGET, 6)

LOAD BCOD,

     MONTH,

     YEAR,

     MONTH2,

     CLA_CODE,

     MONM,

     GROSS_PREMIUM,

     SRCC_PREMIUM,

     REINSURANCE_FUND,

     FOREIGN_COMPANIES,

     CEEDED_PREMIUM,

     NRP,

     UPR_CHARGE,

     NEP,

     SRCC_TC_COMMISSION,

     FOREIGN_CO_COMMISSION,

     COMMISSION_INCOME,

     NET_REVENUE,

     GROSS_CLAIMS,

     CLAIMS_RES_FUND,

     EXGRATIA_CLIMS_RES_FUND,

     CLAIMS_PROCESSING_EXPENSES,

     LEGAL_FEES,

     RI_RECOVERIES_RI_FUND,

     RI_RECOVERIES_SRCC_TC,

     RI_RECOVERIES_FOREIGN,

     SALVAGE_RECOVERIES,

     NET_CLAIMS,

     COMMISSION_EXPENSES,

     PRODUCTION_BONUS,

     DAC_CHARGE,

     ACQUISITION_COST,

     GROSS_PROFIT,

     STAFF_EXPENSES,

     ADMIN_EXPENSES,

     SELLING_EXPENSES,

     FINANCIAL_EXPENSES,

     DEPRICIATION_EXPENSES,

     MANAGEMENT_EXPENSES,

     INV_INCOME_EXT,

     INV_INCOME_INT,

     OTHER_INCOME_EXT,

     OTHER_INCOME_INT,

     INV_OTHER_INCOME,

     NET_PROFIT

FROM

[..\..\..\qlickviwe\P&L\P&LBUDDATA2015.QVD]

(qvd);

sagara

[Gysbert_Wassenaar]

Try something like sum( {<MONTH={"<=$(=max(MONTH))"}>} ACTUAL)

[sagaraperera]

Dear Mr.Gysbert Wassenaar

Thanks your expression is 100% work.thanks dear thanks

sagara

[sagaraperera]

DEAR MR.GYSBERT

CAN YOU HELP SOLVE THIS ISSUE

please advise me as how to get the PREVIOUS MONTH WITH CURRENT MONTH  automatic updated when the month table is selected Eg; When the seletion month is may the PREVIOUS figure should up the value of APRIL.

i give below the my script that was above by me in this connection.

EG;

I WANT TO THIS TABLE

DESCRIPTION          CURRENT MONTH          PREVIOUS MONTH

                                   ACTUAL                    ACTUAL

GROSS PREMIUM          10000                                   5000

MY SCRIPT GIVEN BELOW

CrossTable(DESCRIPTION, BUDGET, 6)

LOAD BCOD,

     MONTH,

     YEAR,

     MONTH2,

     CLA_CODE,

     MONM,

     GROSS_PREMIUM,

     SRCC_PREMIUM,

     REINSURANCE_FUND,

     FOREIGN_COMPANIES,

     CEEDED_PREMIUM,

     NRP,

     UPR_CHARGE,

     NEP,

     SRCC_TC_COMMISSION,

     FOREIGN_CO_COMMISSION,

     COMMISSION_INCOME,

     NET_REVENUE,

     GROSS_CLAIMS,

     CLAIMS_RES_FUND,

     EXGRATIA_CLIMS_RES_FUND,

     CLAIMS_PROCESSING_EXPENSES,

     LEGAL_FEES,

     RI_RECOVERIES_RI_FUND,

     RI_RECOVERIES_SRCC_TC,

     RI_RECOVERIES_FOREIGN,

     SALVAGE_RECOVERIES,

     NET_CLAIMS,

     COMMISSION_EXPENSES,

     PRODUCTION_BONUS,

     DAC_CHARGE,

     ACQUISITION_COST,

     GROSS_PROFIT,

     STAFF_EXPENSES,

     ADMIN_EXPENSES,

     SELLING_EXPENSES,

     FINANCIAL_EXPENSES,

     DEPRICIATION_EXPENSES,

     MANAGEMENT_EXPENSES,

     INV_INCOME_EXT,

     INV_INCOME_INT,

     OTHER_INCOME_EXT,

     OTHER_INCOME_INT,

     INV_OTHER_INCOME,

     NET_PROFIT

FROM

[..\..\..\qlickviwe\P&L\P&LBUDDATA2011_2014.QVD]

(qvd);