This content has been marked as final.
Show 4 replies

1. Re: denominator value changing for different time periods
Vasily Lavrov Jun 20, 2016 12:52 AM (in response to Sunil Pandey)Hi
I attached an example for Index1You should use Level of details to calculate the denominator for all rows partitioned by the Date
For Index1 I calculated the denominator in such way:
{EXCLUDE [Product] : sum( IIF([Product] = 'HEALTHIER BISCUITS',[Price],NULL) ) }For Index2 you should simply change the name of you base product

ChangeDenominator.twbx 31.2 KB


2. Re: denominator value changing for different time periods
Mahfooj Khan Jun 20, 2016 1:24 AM (in response to Sunil Pandey)You can also get the same without using LOD from table calculation. See the attached workbook (version 9.2).
Mahfooj

Table calc index1,2.twbx 28.8 KB


3. Re: denominator value changing for different time periods
Sunil Pandey Jun 20, 2016 2:43 AM (in response to Vasily Lavrov)Thank you Vasily for your help.

4. Re: denominator value changing for different time periods
Sunil Pandey Jun 20, 2016 2:46 AM (in response to Mahfooj Khan)Thank you Mahfooj for showing me another way of getting the desired output.
Much appreciated.
Thanks again!