2 Replies Latest reply on Feb 1, 2019 4:19 PM by Amado Martinez

    Create table, previous year, YTD and All time as columns

    Amado Martinez

      Hello everyone,

       

      I am  trying to create a table that contains previous year (2018) , YTD (2019, broken up by month) and all sales (since inception) as columns ,with measures (sales, qty, avg sale price ,etc) as rows.

       

      I have not created a workbook with this, but I did attach an excel spreadsheet containing a table that I am trying to replicate. i also attached a sample data set for your reference.

       

      thank you for your help, it is very appreciated.