Freeze the values in Chart table

[#1]

Hi,

I need to freeze the values in a field in a chart table. If i select any input in the multibox, the values in that field should not change.

[marcus_malinow]

Hi chaithra,

this sounds like the sort of issue you'd be able to tackle using set analysis.

If, for example your original expression was sum(Sales), and you wished to ignore the selection in a field called 'IgnoreThisField', then change your expression to:

sum({$<IgnoreThisField=>} Sales)

Marcus

[MK_QSL]

Marcus's answer is right if you want your sales value not to change on selecting those field.

SUM({<Year = , Month = , Qtr = , >}Sales)

This will give you same result if you change Year, Month or Qty...

If you want your sales not to change even though change in any field or list box... use below.

SUM({1}Sales)

[brijesh1991]

Go to Document Properties---> General----> Alternate States----> Add---> Give a name to State for example give the name  "a". ----OK

Now go to your chart properties--->General---->Alternate State---> Select "a"---Apply

Now your values won't change with other selections. . .

Regards,

Brijesh

[#5]

Thank u, it worked