Creating detail from high-level data in QV data load
I have a set of numbers summarised by month, that must be loaded into QV as daily data. Something like this:
Store Year Month Sales Budget
1 2000 1 1000 1200
1 2000 2 2100 2100
.... (up to month 12, year 2005)
2 2001 1 500 600
2 2001 2 600 800
..... (up to month 12 and year 2010)
....
I have a data structure set up to deal with daily data and need to get the budget and sales information broken into daily values (e.g. sales for month1 / 31 days, for month 2 divided by 28 days etc).
Is there a way to program something like this into the QV data load? e.g.
