3 Replies Latest reply on Jun 17, 2016 2:55 PM by Deepak Rai

    Filter Values by Year

    Francisco Maresca Neto

      Hi,

      I have an excel file that shows year over year the forecast of my company.

      In the rows I have the product and in the columns I have the year.

      I want to show the forecast but the viewer can see the total forecast and/or can filter by year, is it possible?

      Tableau sees these Year columns as a numeric columns (measures) so I can`t filter that as a date (year).

      Example:

           

      Product2016201720182019
      Furniture $        10,000.00 $  20,000,000.00
      Eletronics $    30,000.00 $  40,000.00
      Administration material $  2,500,000.00 $  100,000.00 $        100,000.00

       

       

      Thank you!