2 Replies Latest reply: Jan 18, 2012 2:29 AM by Sunil Chauhan

# How to calculate only 1 column in the total

 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.

• ###### How to calculate only 1 column in the total

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

• ###### How to calculate only 1 column in the total

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