Variable Year want to link to my excel

[#1]

Hi All,

I have a problem in linking the variable to my field...

excel data

employee details

eno    name   year

1      surya   2003

2      ramu   2004

3     john    2005

now with the above excel data i did a load statement and displaying the values in tablebox.....

now i have created a variable called year and placed the list of values from 2000 to 2020 and placed this in input box...... but i want to know how this will be linked to my table box...... when i change the value in input box the table box is not filtering as required....... am i missing something in this or is there any other method where i can use the variable and filter......

i don;t want to add multibox and add the table field as filter....... want to know how the variables linked to tables..... and use the filters..... thanks in advance.

[#2]

I think  this is not posible, need to use the variable with  a Pivot table or simple table, not with table box.

Regards.-