3 Replies Latest reply on Oct 7, 2013 9:02 AM by Matt Lutton

    Not able to represent data because of data structure in data source.

    Sami Rayes

      http://public.tableausoftware.com/static/images/Da/DateIssue/Sheet1/1.pngI have an Excel file for sales over for multiple customers - the way the file is structured makes it difficult to use dates the way they should be used:

       

      The file has the following columns:

      Customer, Year,      Jan,               Feb,           Mar,           April,      May,      June,        July,       Aug,      Sept,      Nov,      Dec

      Cust1,        2011,      $19,500       $20,000      $22,000     $25,000 $27,000 $28,000    $30,000 $27,000 $50,000 $10,000 $70,000

       

      I can't figure out how to graph the data for each customer over time.

       

      I posted a sample workbook (fake data) on Tableau Public.

       

      I hope the issue is stated clearly - if not, please let me know,

       

      Thanks,