Is it possible to filter Straight table based on input value

[jagannalla]

Hi,

- I have a table with SalID and SalNum. For each SalID there is different SalNum(i.e 1 to 16)

- Now i'm creating straight table with dimension SalNum and expressions as Sum(Debris).

- I have created a Dropdownlist in my sheet with different values(i.e n = 10,20,..500).

- When i Select 20 in the dropdownlist i should get last 20 salID rows data in the straight table.

For This i'm trying to write the set analysis in the expression as follows:

sum({$<SalID ={"$(vCarid)-$(vCarriers)"}>}Debris)

Where vCarId value is---> max(SalID)

vCarriers value is ---> input value

But, it is not working can any one help me?

[vgutkovsky]

Boppy,

If I understood correctly, your dropdown list is a variable? And based on the selected value you want to show that many rows in the straight table, sorted by date? This is quite simple. In the straight table, go to the Sort tab and make sure you are sorting the rows by date descending. Then in the Presentation tab, check "Max Number" and enter the variable there instead of a fixed value.

Regards,