1 Reply Latest reply on May 5, 2018 9:44 PM by Chris McClellan

    Row level costs to column

    Manan Younas

      I have a left join in two tables ( excel sheets )


      The left side table is Cost for every date for several channels.

      The right side table is the cost incurred on multiple channels by date. Therfore, when I join them, there's obvious repetition of date.


      I want that for 1 date i.e. 1-April--2018.  My graph should display the cost per channel for that specific date.


      For example 1-April-2018 , you spent 100 $ in channel 1 , 200$ in channel 2 etc.


      I am not able to do it with FIXED LOD.


      I have attached the Workbook.