2 Replies Latest reply on Aug 2, 2018 1:43 AM by Eoghan Lyons

# Nominal Difference in % Share n Periods Ago

Hi all,

Bit of an unusual one here. I'm looking to see if there is a way to calculate the nominal difference in % share of a total compared to N periods ago.

Example as per the attached workbook. Lets say the "Relative" tab. In this example Brand A makes up 16% of the total in Q1 17 and 30% in Q1 18. These calculations are done on the basis of a single point in time.

Is there however, a way of calculating the nominal difference in overall share in different periods, for arguments sake let's say we want to see what the difference was between n and n-4 periods ago.

Example:

Q1 18: 30%

Q1 17: 16%

30%-16% = 14% nominal share gained.

Many thanks,

Eoghan.

• ###### 1. Re: Nominal Difference in % Share n Periods Ago

Hi 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.

1 of 1 people found this helpful
• ###### 2. Re: Nominal Difference in % Share n Periods Ago

Hi Ankit,

Thanks, this was the calculation I'm looking for. Sorry for the delayed response.