Hide a row with no data in pivot table based on Multibox field selection

[#1]

Hello experts,

As per my project requirement, I havemutibox( categories, style,compnies,..etc)I want to hide only company A,B from list of companies @multibox-> companies,becuase there is no data for these A&B companies.itsshowing blank row at Pivot table. How to block or hide only there twocompnies.

Thanks

[Anonymous]

try,

if(companies<> A or companies<>B,companies)

[#3]

Hello Janet,

Thank you very much for your reply. pleaselet me know where do you wnat me to add this script. is it while loading the data from qvd?

[menta]

Suppress zero value in pivot table settings

[buzzy996]

u can try,

1.Dimension tab-select for which dimension you are having null values -Select check box "Supress when values is null"

[#6]

Hello Shiva,

This is not writing any NULL values, those are showing Zeros ("0") . I dont want to see those company A , Company B from either my Multibox not Pivot table. FYI: those companies names are not comining from DB, those are loading from INLINE table. how to filter them to not to show in Multibox & pivot table?

Thanks for your help.

[#7]

Hello Everyone,

Thanks for your help!

This is not writing any NULL values, those are showing Zeros ("0").Idontwant to see thosecompanyA,Company B from either my Multibox not Pivot table. FYI: those companies names are notcominingfrom DB, those are loading from INLINE table.howto filter them to not to show in Multibox & pivot table?

Thanks

San

[buzzy996]

try like this,

load ur inline table into another table by using resident and use where clause where company/ur dimension field <>0 ;