Hide zero value

[#1]

Hello

I have a pivot table with a sum field, and i want to hide the line if value in this field "Generalkost" is 0. How is this poible?

//Gunnar Schie\\

[#2]

properties--> dimension--> select field--> then check supress null value

[#3]

try this

if(Generalkost<>0,Generalkost)

[#4]

Where can i write?

[#5]

I tryed the "check supress null value in dmension"

and in presentation tab try to "supress zero values" in presentation tab, but nothing happend.

I send the QvW file, look at the tab Generalkostnader

Gunnar

[kumarnatarajan]

Hi,

Go to properties tab then check the "Suppress Zero Value" this very simple one.

else

put condition your expression level

[kumarnatarajan]

Hi,

share your expression syntex. can i help you

[kumarnatarajan · Accepted solution]

Hi,

Nm field use to dimention. find the attached file

[#9]

Yes i works, but i want to show prNr and PrName in pivot table, like:

162 - Vedlikehold grøntarbeider - serie_ - serie_2 ..........................

How to do this`

Gunnar

[kumarnatarajan]

Hi,

Go to Presentation tab then check the "Always Fully Expandad"