how to hide something on a table

[Anonymous]

hi all

not sure if this is possible be see below..

in the fabric group column..

on the bottom there are blanks.. or nulls..

how do I not load that in the table without using the suppress null function in the table?

thanks

[#2]

The one option is to remove the Partial sum option in the properties tab. But it lost total on the body class as well. Do you want show the null value in the Fabric Group column ?

[MK_QSL]

Your Expression......

SUM({<Fabric = {'*'}>}Sales)

Change your expression accordingly..

[Anonymous]

hi..

that's exactly it.. I do not want null to show up on the fabric group column..

I thought I could do that somehow in the dimension field with a if statement but not sure...

if(fabricgroup =' ' then ??

something like that

thanks

[Anonymous]

hi manish

not sure what this will do..

but the aggr and sums work..

I just like if fabric group = null hide somehow

thanks

[MK_QSL]

provide sample data.. will do it for you..

[el_aprendiz111]

Hi,

SUM({$<FABRIC={'*'} - {' '}>}SALES)

[HirisH_V7]

Hi,

Include this in all of your set expressions,

=sum({$<[Fabric Group]-={"=len(trim([Fabric Group]))=0"}>} [Total Units])

HTH,

Hirish

[#9]

Fabric Group and Body Class both are coming from same table or different tables ? The issue here you may dont have proper fabric group for your Body class and Fact value. So it showing null value in the fabric group. If you don't want load null Fabric group values, discard those data across all the tables in the script level.

[Anonymous]

hi srikanth...

yes there is bad data that's why this is showing up the way it is..

the thing is I can remove it from the load.. so it doesn't even load in but it helps me catches missing data or badly entered stuff.. so I can go back and correct.

that's why im wondering if I can use an expression to get rid of it on the table itself.

thanks