Pivot table

[#1]

Hello

i have a probleme with the sum in the pivot table.

Chantier	Genre	Type	Serie	Cout du matériel 13 650	Prix	Nombre Engin 39
Total				13650	350	39
CARRIERE ROMMANA GABES	Total			13650	350	39
	PELLE	Total		1050	350	3
		R170	N50311847	1050	350	3
	CHARGEUSE	Total		0	0	18
		HL770	LBO411256	0	0	18
	GROUPE ELECTROGENE	Total		0	0	18
		3406	9ES2419	0	0	18

i have a problem with the sum of the table.

the logic total is (3*350=1050)

but QV recalculate the sum in the total of the expression in the end of dimension ( 39 * 350 = 13650) but the right sum of the first (1050+0+0))

how can i correct it

thanks

[#2]

do not use sum() function in "Prix" and "Nomber Engin 39".......

just use it as it is ,means just field name without any function.

regards,

Dixit

[pover]

If the column "Prix" has a sum and "Nombre Engin 39" has a sum you can't use a sum(Prix * Nombre Engin 39) anyway. Use the expression within "Prix" and "Nombre Engin 39" and make sure it is a sum(x*y) and not a sum(x)*sum(y).

Regards.

[#4]

Hi,

thank you for yours responses .

in the begening i would to explain the goal of the table: i want to calculate the cost of rent of the cars, So this cost is the number of the day ( Nombre Engin) * the price of the day ( Prix).

when i execute your recommendations, i have this results :

Chantier	Genre	Type	Serie	Cout du matériel 23 450	Prix	Nombre Engin 67
Total				23450	350	67
RVE 543 CHOUTRANA	Total					28
	CHARGEUSE	Total				28
		938F	2RM1120			28
CARRIERE ROMMANA GABES	Total			13650	350	39
	GROUPE ELECTROGENE	Total				18
		3406	9ES2419			18
	CHARGEUSE	Total				18
		HL770	LBO411256			18
	PELLE	Total		1050	350	3
		R170	N50311847	1050	350	3

the expression is

*Prix = Prix

* Nombre Engin= count(Suivi_Engin.Journee)

* Cout du matériel= Prix * count(Suivi_Engin.Journee)

so the problem, i don't have the number of day of rent, i count this in the table.

I 'm waiting for your helps

Thank you.