data filter in straight table?

[#1]

hi all

i have small query in my tables please tell me any one. the query

name       address        1      2      3     4     5    6    7    8

--------       -----------       ----    ---     ---    ---    ----  ---  ---   ---

   a              abcd          n     n       n    n      n    n    n    n

   b              dcba          f      f        f    f       f     f     f    f

   c               gnd           n     n       n    n      n    n    n   n

   d               ssss          f    f         f     f      f     f      f   f

   e                wwww      n    n        n    n     n    n      n  n

   f                rerer           f    f         f    f      f      f      f   f

i want out put  blow please observe. 

name       address    1     2      3    4    5    6    7    8

--------       -----------    ---    ---    ---   ---   ---   ---  ---   ---

  a            abcd        n     n     n    n    n     n   n     n

  c             gnd         n    n      n    n    n     n   n     n

  e            wwww     n    n      n     n   n     n   n     n    

is their any script or images or files please forward me.

  thanks

subbu    

[vinieme12]

Hi ,

It Seems Like you want to suppress specific names in your straight table

Use the below in your dimension

=if(wildmatch(name,'a','c','e')>0,name)

and then Check Suppress when Value is Null

[#3]

My dummy method: Straight table, Dimensions: Field "name" to "7" Expression:sum(if(field1 &...field8=n,field8,)) as field 8

[vinieme12]

Hi ,

Please see attached QVD for the below. There are two ways in which you can achieve this.