Grouping in set analysis and dispersing values in per dimension

[cristianj23a]

Hi Guys.

I have a simple table where the overtime hours that are grouped by the Payroll are evaluated.

I'm trying to get the total sum of overtime per payroll. Example:

Field CC_NÓMINA = 'HORAS EXTRAS 25%' has a total of 32 extra hours. This value has to be repeated in the rows that have

'HORAS EXTRAS 25%', just like the COST_PEN_TEST column.

I am trying to do in script because it is more optimized, if not it can be in set analisys, but I would like in Script.

Please help me with this topic.

attached qvw

Greetings. !

[olivierrobin]

hello

create a first table  with the key and the sum

load your table

left join the 1st one on key and you will have your value on each row

[cristianj23a]

Hi,Olivier.

I also take that step but it does not show me the total, only the sums.

SET_H.EXTRAS:

LOAD

LLAVE_NOM,

Sum(DISTINCT H.EXTRAS)  AS TH.EXTRAS

Resident TABLE_H.EXTRAS Group By  LLAVE_NOM;

Greetings..

[sunny_talwar · Accepted solution]

May be try this

Sum(TOTAL <CC_NÓMINA_DESC> Aggr(Sum(DISTINCT {<CC_NÓMINA={'9066','9088','9067','9089'}>} H.EXTRAS),PERIODO,CC.SEDE,FECHA,[N° PERSONAL_CC],CC_NÓMINA_DESC))

or

Sum({<CC_NÓMINA_DESC>}Aggr(NODISTINCT Sum(Aggr(Sum(DISTINCT {<CC_NÓMINA={'9066','9088','9067','9089'}>} H.EXTRAS)

,PERIODO,CC.SEDE,FECHA,[N° PERSONAL_CC],CC_NÓMINA_DESC)),CC_NÓMINA_DESC))