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 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

[muthukumar77]

Hi,

Try like this,

Dimension: Name and Address

Expressions:

Sum({<1={'n'}>}1)

Sum({<2={'n'}>}2)

Sum({<3={'n'}>}3)

Sum({<4={'n'}>}4)

Sum({<5={'n'}>}5)

Sum({<6={'n'}>}6)

Sum({<7={'n'}>}7)

Sum({<8={'n'}>}8)

[vinieme12]

Hi, can you please post a sample of the data? So people here can help you better.

Cheers

V

[vinieme12]

Hi,

Please see attached.