2 Replies Latest reply on Feb 1, 2019 3:20 PM by Amado Martinez

    Help with Tables. Add date to columns and % Difference in column Measures in rows

    Amado Martinez

      Hello everyone,

       

      I am having a hard time figuring this out. I want to create a table where the date of order is in the column (per week) and the measures are in rows (# qty ordered, sum of sales, etc). I would also like to add a % of difference as a column.

       

      So far, the only thing I can think of is to create 2 tables and overlay them on top of each other in the dashboard so that it looks like % of difference is next to the date columns.

       

      the attached workbook shows my workaround, and what I am trying to accomplish, but I think there has to be a less cumbersome way.

       

      thank you ahead of time for your help with this question.

       

      Regards,

       

      Amado