1 Reply Latest reply: Mar 28, 2017 3:28 PM by omar bensalem RSS

    Create a filter based on excel columns

    Mark Ritter

      My data source in an excel spreadsheet.  Each row is a Branch.  Each column is a year (2010 - 2016).

       

      I have loaded the data into a table and I want the user to be able to pick a year and limit the data that is visible.  I am not sure if or how I can do this with excel. 

                       2010   2011     2012  2013   2014  etc.

      Branch A     100     200     300     500     700