I am trying to dissagregate this data to make it match our standard workflow for Sales Funnel, data is different because it is coming from a different BU.
Need to convert this:
date
Leads
NewSales
1/2/2017
2
1
1/3/2017
3
2
Into this
date
Leads
NewSales
1/2/2017
1
1
1/2/2017
1
0
1/3/2017
1
1
1/3/2017
1
1
1/3/2017
1
0
Have been trying for a with different methods without success.