sum total error in table

[ecabanas]

    Hi,

I have an error in total cost field. The TOTAL in cost field did not sum correctly,

Anyone knows how to fix it?

Many thank's

[Kushal_Chawda]

What is the error?

[swuehl]

Try

sum( Aggr(

(sum ({<CalendarYear =,CalendarMonthName=,CalendarMonthAndYear={">=$(=addmonths(max(CalendarMonthAndYear),-1200)) <=$(=Max(CalendarMonthAndYear))"}>} UNIDADES)*-1)

*

Avg ({<CalendarYear =,CalendarMonthName=,CalendarMonthAndYear={">=$(=addmonths(max(CalendarMonthAndYear),-1200)) <=$(=Max(CalendarMonthAndYear))"}>} WAC)

,DES_FAMILIA,DES_SUB1,DES_SUB2,ITEMID,ITEMNAME)

)

[ecabanas]

Hi Kush

Sorry the error is inside the doc. The TOTAL in cost field did not sum correctly,

[ecabanas]

Hi swuehl

If I apply your formula, see that there are some lines not multiplying:

[Kushal_Chawda]

Hi,

You need to aggregate it by all the dimensions of the pivot table.

Please see the attached

[swuehl]

Can't reproduce your data, have you changed the selection compared to the uploaded version?

edit: third line shows only 5 units at my version, and it does multiplicate to cost

[ecabanas]

Hi swuehl

Yes I update the date but the problem is the same, there are 6 units, cost, but not multiplies and I don't know why

[ecabanas]

Hi Kush

Now it sums but there are some lines not multiplying, you know why?

Many thank's

[swuehl]

What do you mean 'I update the date', have you reloaded it?

I do get a full set of cost and total with your original file.

Family	DES_SUB1	DES_SUB2	ITEMID	ITEMNAME	Units	Avg WAC	Cost
Total					11	9,51	79,31
08.BEBE E INFANTIL	14.VIAJE	06. BASES Y FIJADORES DE SILLA	10363680	BASE BEBE CONFORT 2WAYFIX NEGRA	0	127,60	0,00
			10363787	PARASOL ENROLLABLE BEBE CONFORT	1	8,03	8,03
			10363788	KIT DE VIAJE BEBE CONFORT	5	10,20	51,00
			10363789	RETROVISOR BEBE CONFORT	0	2,55	0,00
			10363790	REPOSACABEZAS DE VIAJE BEBE CONFORT	5	4,05	20,27

To see you issue, please describe what you have changed or upload a new sample file.