How to calcualate product mix within a category?

[Former Member]

We have a requirement of calculating product mix within a product category. E.g. We have 2 product categories Sports drink and Energy drinks, within this we have 3 products each A,B,C for sports drinks category and D,E,F for energy drinks category

Sales and the desired output(product mix) are as follows:

[former_member217157 · Accepted solution]

Hi Navneet

Assuming SALESQTY is defined by Month, Product and Product Category is an attribute of Product. Then you can achieve PRODMIX using the following calculation

HSALESQTY@MTHPROD = SALESQTY@MTHPROD :

HSALESQTY@MTHCATG = SUM(HSALESQTY @MTHPROD)

PRODMIX@MTHPROD = SALESQTY@MTHPROD /HSALESQTY@MTHCATG

Hope this helps.

Regards,

Raghav

[Former Member · Accepted solution]

Hi Raghav,

Thanks for your inputs.

I tried the solution you suggested, i am able to get the correct values for the product mix but the issue I am facing is now in the representation in the excel add-in planning views.

My desired output is:

While the output i am getting is:

Please note that the values calculated are correct but for a category i am getting all the products which is very misleading.

What might i be doing wrong.

[former_member217157 · Accepted solution]

Hi Navneet,

Can you send screenshots of the planing levels showing all attributes.

Thanks,

Raghav