Dimension filter

[#1]

Hi,

I only want to show the result of the table below if user select POStatus='200' from the DimensionTable. Please assist.  I tried this if(GetSelectedCount(POStatus='200,OMSPO#) but failed. OMSPO# is the key. Thank you.

[#2]

is there a link between POStatus and OMPSO#?

selecting a field to filter from will work if there is a relationship between the filtering field and the field to be filtered?

can you post the qvw?

[Peter_Cammaert]

GetSelectedCount() returns the number of selected values in a Field/Listbox, not the actual selected values.

You need GetFieldSelections(POStatus) = '200'.

If a user selects value 200, do you want to show the straight table, the total of the expression or something else entirely?

[#4]

I agree with Peter that the syntax you are using is not correct, but how is the POStatus related to the OMSPO#?  Is there a linked table?  Is the POStatus field in a different table.If it was in the dame table as the other data, selecting the value from the lsit box would ahve filtered your data.

positing the qvw or data model would helo