Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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