filling missing data from previous

[gauthamchilled]

Hi,

I have only quarterly data. I want to make it monthly. I currently have data for mar,jun,sep and dec.
i want from jan to dec. Meaning...

for

jan-previousyear dec data
feb-previousyear dec data
mar- actual march data
apr- march data
may-march data
jun- actual jun data
jul-jun data
aug-jun data
sep- actul sep data
oct-sep data
nov-sep data
dec-actual dec data

i following generate missing data by HIC by couldnt succeed, any one help pls

[settu_periasamy]

Hi Gautham,

Check the Attachment. May be helpful.

[gauthamchilled]

Hi Settu,

When I  use your example, it is not still showing the quarter dates after join.

While I debug by renaming Date as Date 1 , I could see all the dates in Date1, but to join(Date instead of Date1) I see quarterly dates only

Load Date(Floor(Addmonths($(vMinDate),RecNo()-1))) as Date1 Autogenerate vMaxDate-vMinDate;

can you help?

[settu_periasamy]

Hi Gautham,

is it possible to provide the expected output in excel?

[gauthamchilled]

Settu,

Thanks for your help.

If I select ABC it should show sales for all the dates, if I select DEF it should show for all the dates.

If actual data is null, then it should pick from previous available data and show. Currently it is not showing for all the dates in your example.

[gauthamchilled]

for selection ABC expected output is

31/12/2014	ABC	3000.00	2014	Dec
31/01/2015	ABC	3000	2015	Jan
28/02/2015	ABC	3000	2015	Feb
31/03/2015	ABC	4000	2015	Mar
30/04/2015	ABC	4000	2015	Apr
31/05/2015	ABC	4000	2015	May
30/06/2015	ABC	9000	2015	Jun
31/07/2015	ABC	9000	2015	Jul
31/08/2015	ABC	9000	2015	Aug
30/09/2015	ABC	4000	2015	Sep
31/10/2015	ABC	4000	2015	Oct
30/11/2015	ABC	4000	2015	Nov
31/12/2015	ABC	4000	2015	Dec

[gauthamchilled]

Also, if I select 2014 year it is showing 2015 dates mixed with 2015 in your example

[MayilVahanan]

Hi

PFA

May be its help

[gauthamchilled]

Thanks Mayil,

May I know why Date and Date 1 is not joining ?

[MayilVahanan]

For create cross join