on 09-03-2015 6:49 AM
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:
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
8 | |
4 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.