2 Replies Latest reply: Apr 16, 2012 12:36 PM by Bill Cabiro RSS

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

    Bill Cabiro

      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

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

          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