How to calculate only 1 column in the total

[#1]

Center	CONSOLIDATED  TOTAL			Center  1000			Center  1010			Center  1900
	Cost	KG	Prom	Cost	KG	Prom	Cost	KG	Prom	Cost	KG	Prom
TOTAL	1.165.371.999	-	-	457.638.353	-	-	472.287.753	-	-	235.445.893	-	-
Item 1	1.068.200.953	-	-	422.519.446	-		436.153.156	-		209.528.351	-
Item 2	97.171.046	2.830	34.330	35.118.907	707	49.648	36.134.597	552	65.503	25.917.542	1.571	16.493

Center	CONSOLIDATED  TOTAL			Center  1000			Center  1010			Center  1900
	Cost	KG	Prom	Cost	KG	Prom	Cost	KG	Prom	Cost	KG	Prom
TOTAL	1.165.371.999	-	-	457.638.353	-	-	472.287.753	-	-	235.445.893	-	-
Item 1	1.068.200.953	-	-	422.519.446	-		436.153.156	-		209.528.351	-
Item 2	97.171.046	2.830	34.330	35.118.907	707	49.648	36.134.597	552	65.503	25.917.542	1.571	16.493

I need to show only the column 'Cost', the columns 'KG' and 'Prom.' are empty. Thanks.

[lironbaram]

hei

in pivot table the basic rule is it calculate the total for all the expression

but you can change your expression to smoething in the lines of

if(isnull(only(Item))=0,sum(KG))

in that way it want calculate a total for the expression KG

[SunilChauhan]

convert to straight table

then go to expression-> seleect no total for

KG' and 'Prom.'

and theen again convert to pivot table

hope this helps