This content has been marked as final.
Show 2 replies

1. Re: Nominal Difference in % Share n Periods Ago
Ankit Bansal Jul 24, 2018 8:04 AM (in response to Eoghan Lyons)1 of 1 people found this helpfulHi Eoghan,
First you need to derive ratio with a formula:
sales total ratio:
{fixed [Brand],year([Date]),DATEPART('quarter',[Date]): sum([Sales])}/{fixed year([Date]),DATEPART('quarter',[Date]): sum([Sales])} * 100
then use below formula to find the nominal diff:
sum([sales total ratio])LOOKUP(sum([sales total ratio]),4)
for 4 you can make parameter .
Attaching the workbook for reference.
Basically u first need to find ratio across table and then nominal difference table down.

2. Re: Nominal Difference in % Share n Periods Ago
Eoghan Lyons Aug 2, 2018 1:43 AM (in response to Ankit Bansal)Hi Ankit,
Thanks, this was the calculation I'm looking for. Sorry for the delayed response.