How to delete data in fields through script

[venkat1]

Hi all,

I have a pivot table (file attached),here i dont want to show  specific value  in pivot table,is there any option to not to show this value in table?

[MindaugasBacius]

There are the few options:
1. Use Set analysis
2. Remove it while loading data with Where statement
3. Use Sheet Triggers to ignore it

[martinpohl]

don't know your expression but use set analysis

sum({<Dim2 -={'Jamnagar'}>} value)

Regards

[venkat1]

Can you please expalaim me on removing by where statement and sheet triggers?

my data is like

A                        B                                    

usa             SFO

uk                scot

usa             SFO

                     texas

here i want to remove sfo from third  row .