
1. Re: Calculation of Mix
Benjamin Greene Oct 5, 2016 6:34 AM (in response to Niranjan Banarjee)You could achieve this with a LOD or a Table Calc. I prefer LODs. It's tough to get the exact formula without a packaged workbook or more context, but:
SUM([Measure])/SUM({FIXED [Category] : SUM([Measure])})
This will give you each SKU value as a portion of the total within the Category.

2. Re: Calculation of Mix
Niranjan Banarjee Oct 5, 2016 6:39 AM (in response to Benjamin Greene)Thanks Benjamin will try and revert.
I believe if we change the Category to Brand/SKU then it should give me within the same.
The same formula should work.

3. Re: Calculation of Mix
Niranjan Banarjee Oct 5, 2016 7:36 AM (in response to Niranjan Banarjee)Hi Benjamin,
I am trying to add a calculated field(CTG) in the same Table after growth.
My growth formula used is as below:
(sum([YTD June 2016])sum([YTD June 2015]))/sum([YTD June 2015])
Which formula should i use to calculate CTG?
CTG= (YTD June 2016 YTD June 2015)/Brands Total(row) YTD June 2016YTD June 2015 as per the above picture shared.
Can you please help with this.

4. Re: Calculation of Mix
Niranjan Banarjee Oct 5, 2016 8:18 AM (in response to Niranjan Banarjee)Is it possible?