exclude records

[#1]

I know that you can exclude record in a script but I'm using the same script for mulitple things.

On this one sheet I need to exclude all [suspend code balance] = ['N'} from the selection for this sheet.

How can I do that? I don't want the stock numbers to show up in the chart  unless some of the records for that item are "N"

[MayilVahanan]

Hi

Try alternate state for that particular field

Hope that helps

[#3]

Hai

try with alternate states for solving u r problem.In alternate states u can use it seperately for different sheets on selections.

it may helps u

[whiteline]

Hi.

You can use set analysis to modify selections for a particular expression and exclude some values, for example:

Sum({<[suspend code balance] -= {"N"}>} Value)

[jagan]

Hi,

You can exclude the values of dimension by using "-=" operator.  For example

=Count({<[suspend code balance] -= {'N'}>} DimensionName)

Hope this helps you.

Regards,

Jagan.