"spread down" to lower date and dimension level of granularity...

[#1]

HiI've got a quick question: 

I have a Budget Table that is at high level (Brand and Month).   Can QV allocate or "spread down"  the numbers by data and Product SKU (provided in different tables) or I need to do that in Excel?

Thanks for your help. Bill

[kaushiknsolanki]

Hi,

   Try this script.

Data:

LOAD Date, //Month (Date) as Month,

           Month (Date)&Brand as [Mo-Brand],

           SKU,

     Brand,

     Sales

FROM

[Turkey Budget QV Brand Allocation Test.xlsx]

(ooxml, embedded labels, table is Sales);

SKU:

Load distinct SKU as sku Resident Data;

let vSKUCount = FieldValueCount('SKU');

Drop table SKU;

LOAD //Brand, //Month (Month) as Month,

left ( Month,3)&Brand as [Mo-Brand], [Bud Sales]/$(vSKUCount) as [Bud Sales]

FROM

[Turkey Budget QV Brand Allocation Test.xlsx]

(ooxml, embedded labels, table is Budget);

LOAD Month (Date) as Month, Xge

FROM

[Turkey Budget QV Brand Allocation Test.xlsx]

(ooxml, embedded labels, table is Xge);

Regards,

Kaushik Solanki

[#3]

Kaushik, Thanks for the fast reply.  This seems to be a step in the right direction but there is still a problem.

It's not allocating by date.

Thanks and Regards, Bill