Acumulados con Pick y Match

[__Paco]

Buenos días,

Estoy intentando calcular los acumulados del año para esta medida:

Pick(Match(Dim_CTARESULT_1,'VENTAS NETAS',
'CONSUMOS',
'MARGEN BRUTO',
'MARGEN BRUTO EN %',
'GASTOS DE PERSONAL',
'GASTOS DE PERSONAL GRUPO 64',
'TRABAJO TEMPORAL',
'GASTOS DE EXPLOTACIÓN',
'ARRENDAMIENTOS Y CANONES',
'GASTOS I+D DEL EJERCICIO',
'REPARARACIONES Y CONSERVACION',
'SERV. PROF. INDEPENDIENTES',
'TRANSPORTES',
'PRIMAS DE SEGUROS',
'SERV. BANCARIOS Y SIMILARES',
'PUBLICIDAD PROPAGANDA Y REL. P.',
'SUMINISTROS',
'OTROS SERVICIOS',
'OTROS TRIBUTOS',
'AMORTIZACIONES',
'PROVISIONES',
'BENEFICIO EXPLOTACIÓN (BAIT)',
'GASTOS FINANCIEROS NETOS',
'RESULTADO ORDINARIO',
'RDOS. EXTRAORDINARIOS',
'RESULTADO',
'RESULTADO ACUMULADO')

Por ejemplo para ventas netas aplico esto, pero no me funiciona
,Sum(TOTAL<Mes_Consulta>{<MC_Compañia={'00001'},Año_Consulta={'$(vCurrentYear)'},Fecha_Consulta,Mes_Consulta={'<=$(=Getfieldselections(Mes_Consulta))'},MC_LibroContable={'AA'},PLANC_CAT29={'CR.1'}>}MC_Saldo)*-1

[JordyWegman]

Hi Paco,

Could you mention in English what your question is and what you want to accomplish?

Jordy

Climber

[__Paco]

Good morning,

I am trying to calculate the accumulated of the year for this measure:

Pick(Match(Dim_CTARESULT_1,'NET SALES',
'CONSUMPTION',
'GROSS MARGIN',
'GROSS MARGIN IN %',
'PERSONAL EXPENSES',
'PERSONNEL EXPENSES GROUP 64',
'TEMPORARY JOB',
'OPERATING EXPENSES ',
'LEASES AND CANONS',
'R&D EXPENSES FOR THE YEAR',
'REPAIRS AND CONSERVATION',
'SERV. PROF. INDEPENDENT',
'TRANSPORTATION',
'INSURANCE PREMIUMS',
'SERV. BANKING AND SIMILAR',
' ADVERTISING PROPAGANDA AND REL.P.',
'SUPPLY',
'OTHER SERVICES',
'OTHER TRIBUTES',
'AMORTIZATION',
'PROVISIONS',
'OPERATION PROFIT (BAIT)',
'NET FINANCIAL EXPENSES',
'ORDINARY RESULT',
'RDOS. EXTRAORDINARY',
'RESULT',
'ACCUMULATED RESULT')

For example, in order to calculate 'ACCUMULATED RESULT'  which is the total of the summary of each month of the year, I apply the next operation:
Sum(TOTAL<Month_Consultation>{<MC_Company={'00001'},Year_Consultation={'$(vCurrentYear)'},Date_Consultation,Month_Consultation={'<=$( =Getfieldselections(Month_Consultation))'},MC_BookBook={ 'AA'},PLANC_CAT29={'CR.1','CR.2','CR.3'}>}MC_Balance)*-1

[__Paco]

Good morning,

I am trying to calculate the accumulated of the year for this measure:

Pick(Match(Dim_CTARESULT_1,'NET SALES',
'CONSUMPTION',
'GROSS MARGIN',
'GROSS MARGIN IN %',
'PERSONAL EXPENSES',
'PERSONNEL EXPENSES GROUP 64',
'TEMPORARY JOB',
'OPERATING EXPENSES ',
'LEASES AND CANONS',
'R&D EXPENSES FOR THE YEAR',
'REPAIRS AND CONSERVATION',
'SERV. PROF. INDEPENDENT',
'TRANSPORTATION',
'INSURANCE PREMIUMS',
'SERV. BANKING AND SIMILAR',
' ADVERTISING PROPAGANDA AND REL.P.',
'SUPPLY',
'OTHER SERVICES',
'OTHER TRIBUTES',
'AMORTIZATION',
'PROVISIONS',
'OPERATION PROFIT (BAIT)',
'NET FINANCIAL EXPENSES',
'ORDINARY RESULT',
'RDOS. EXTRAORDINARY',
'RESULT',
'ACCUMULATED RESULT')

For example, in order to calculate 'ACCUMULATED RESULT'  which is the total of the summary of each month of the year, I apply the next operation:
Sum(TOTAL<Month_Consultation>{<MC_Company={'00001'},Year_Consultation={'$(vCurrentYear)'},Date_Consultation,Month_Consultation={'<=$( =Getfieldselections(Month_Consultation))'},MC_BookBook={ 'AA'},PLANC_CAT29={'CR.1','CR.2','CR.3'}>}MC_Balance)*-1

[JordyWegman]

Do you maybe have a QVF that I can work with? Because the Pick(Match()) combination seems a bit strange at first. But with some data it becomes a bit easier.

Jordy

Climber