I have a data file with data of 2012 and 2013, I want to have the 2012 data appear on a Tab called 2012 and the 2013 data on the Tab 2013, the third tab is called Dashboard and should have all data.
Is it possible to filter the data per Tab based on Expressions?
if you mean tab is sheet. you can create text objects to navigate between sheet (using actions ex: activate sheet), you can add another action on the same text obj 'select in field' and give field name as year and value 2012, on the 2013 , you can have a action to clear the Year field and have select in field. and i prefer to avoid triggers when possible.
yes you can do that ... if you go to Sheet properties and then apply triggers as shown in the screen shots. And do the same in another sheet for year 2013. Hope this helps if it does not help post the qvw file we can help you with that
