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.