My WAD template has 2 items one dropdown for Calendar Year and another is the query which has key figures like Actuals and Previous year sales.
Now my requirement is that as and when i select a Calendar Year in the dropdown my values in table should change accordingly( Obviously).
That means i need to somehow pass the value which is finally selected in the drop down back to my
query so that my key figures can change there values accordingly.
Can you please let me know how to do it.