2 Replies Latest reply on Apr 4, 2012 10:27 PM by Nathan Schofield

Percentage Change of Market Share

Nathan Schofield Mar 31, 2012 7:54 PM

Hello,

I have a simple example workbook attached. It contains name, week, and sales. I have calculated:

% difference of sales from previous week; and
% of total sales (market share)

What I do want to calculate is % change in market share from previous week. I have attempted to do this in the past, but I think the reason I got stuck is that it requires calculation across(previous period) and down(market share). If someone could please help by showing me how to do this in the attached workbook it would be greatly appreciated.

Regards,

Nathan

Percentage Change of Market Share.twbx.zip 4.8 KB

1. Re: Percentage Change of Market Share

Dimitri.B Apr 4, 2012 7:47 PM (in response to Nathan Schofield)
See attached workbook for a solution. The important part, as you correctly pointed out, is to partition a table calculation in two ways at the same time. To do this, you feed the results of one table calc to another, and then partition the latter using the selector, as shown below.

Percentage Change of Market Share (edit DB).twbx.zip 24.3 KB
Like Show 0 Likes(0)

Actions
2. Re: Percentage Change of Market Share

Nathan Schofield Apr 4, 2012 10:27 PM (in response to Dimitri.B)

Hi Dimitri,

Fantastic. Exactly what I was looking for. Thank you very much for your help.

Regards,

Nathan
Like Show 0 Likes(0)

Actions