Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to withdraw $ syn are cause it to below picture. Why are the sketch and description, claims a table number. Method to clarify concerns, and to make the table from $ syn.
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);
Concatenate
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);
Concatenate
Directory;
CrossTable(DESCRIPTION, Data, 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&LDATA2011_2014.QVD]
(qvd);
Concatenate
Directory;
CrossTable(DESCRIPTION, Data, 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&LDATA2015.QVD]
(qvd);
Directory;
LOAD NO,
ACCOUNTANT,
AC_NO,
BCOD,
REGION,
BRA_CAT,
BRA_DBASE,
BRANCH,
DEPT
FROM
[..\..\qlickviwe\Branch.qvd]
(qvd);
please help
sagara
