how to hide a value in a pivot table

[Anonymous]

Hi

In my report I want a value against itemnumber ie 50,76,56,4,62,248 should be hidden or removed from table.

pLease help!!!!

report screenshot is attached below

[#2]

you can use not equal to operator for this

[dineshm030]

Hi Saksham,

There is no HIDE option in pivot table. Instead of Pivot table you can use Straight Table. It has a HIDE option for the field.

Regards,

Dinesh Kumar.

[Anil_Babu_Samineni]

May be expression like below

Sum({<ItemNumber -= {'50','76','56','4','62','248'}>} Measure)

[Anonymous]

i have used rangesum() function as rangesum(north,south,east,west,tbc) but not please tell me how to apply not equal to operator ?

[Anil_Babu_Samineni]

Why not this?

Only({<ItemNumber -= {'50','76','56','4','62','248'}>} rangesum(north,south,east,west,tbc))

[Anonymous]

thanks...it was useful for me

[Anil_Babu_Samineni]

Please close this thread by flag Helpful and Correct Answer to close this thread

Note - Please free to ask if issue still not resolved.