Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to cumulative value it should be a related to month value eg feb 2015 value related to jan 15 + feb 15. i have a month field it was select to month of feb cumulative value should be Shawn on only jan and feb15
can i help me
sagara
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);
You can use a combination of Aggregate, RangeSum and above functions to achieve what you are trying to do. This is the best I can help you with amount of information you have provided here.
Best,
Sunny
When I need a month of compensation to the value of the current value of the previous several months plus CUMULATIVE get appreciated.
When I need a month of compensation to the value of the current value of the previous several months plus CUMULATIVE get appreciated.
sagara
Would you be able to provide sample data or application to work with?
Best,
Sunny
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);