Need to make appear only values >0

[nevilledhamsiri]

once data are loaded &  the table created  of which a measure column gets values like 250,250,0,0,0,0,250,0,0 & so on. If I am to restrict the measure column to appear only rows which carries 250, what could be the function applicable. My Dimensions & measures are as follows!

Name  Class  Penalty

A          MO          250

B          MO          0

C          MO          250

D          MO          0

E          MO          250

Thanks

Neville

[swuehl]

Have you enabled 'suppress zero values' on presentation tab?

[sergio0592 · Accepted solution]

Hi,

As calculated dimension put :

Name=if(aggr(sum(Penalty),Name,Class)>0,Name)

Class=if(aggr(sum(Penalty),Name,Class)>0,Class)

And check for dimensions "suppress when value is null"

[sergio0592]

Or more easily as Stefan said, just check Supress zeor value in presentation tab.