Show specific record in straight table

[#1]

Hi all

Have a straight table as below:

Month          Name     TM               Limit     Balance

Mar 2013     A            Non Target   12          13

Mar 2013     B            Select          24          6

Mar 2013     C            Non Target    15          14

Mar 2013     D            Target           8           13

Any guidance to show the records with Non Target only

rgrds

[Gysbert_Wassenaar]

You could simply add a listbox for the TM field and select Non Target in it. But if you want that selection only for the straight table you can use a calculated dimension instead of TM, i.e. if(TM='Non Target',TM), and check the Suppress When Value is Null option for the calculated dimension. You can also put the filter in all the expressions: sum({<TM = {'Non Target'}>} Limit) and sum({<TM = {'Non Target'}>} Balance).

Another option in QV11 is to use an alternate state for both a listbox and the straight chart so selections in the lisbox only apply to the straight chart since it's in the same alternate state as the listbox.