3 Replies Latest reply on Dec 14, 2012 8:36 AM by Matylda Borchert

# YoY difference in % for a dynamic time frame

Hi,

I need absolute values as well as YoY difference for sales in % for the current year and a previous year. The challenge is that I want to compare the same time frames.

In my example year 2012 includes just values for the first 3 quarters (Q1-Q3); year 2011 is so far completed (Q1-Q4), at the end, these are the numbers that I want to report:

Sales 2011 (Q1-Q3): 952.188

Sales 2012 (Q1-Q3) : 931.154

YoY difference: -2,21%

How can I achieve this?

Thanks for your support, Matylda

• ###### 1. Re: YoY difference in % for a dynamic time frame

Cheers, Matylda

• ###### 2. Re: YoY difference in % for a dynamic time frame

Did you still need help with this Matylda? It looks like the packaged workbook already contains the desired values.

• ###### 3. Re: YoY difference in % for a dynamic time frame

Good morning Tracy!

Thanks for getting back to me. I have not solved this problem yet, the workbook contains values where the time frames do not adjust, however I need a dynamic solution.

Cheers, Matylda

Hello Tracy!

I am really stack I don’t know further, I went through the posts on “yoy change, ytd comparisons”, however they aim slightly different goals. I thought I send you my Dashboard so you can see where I want to implement the” yoy change in % to YTD/previous year” (KPI workbook).

I have further questions and I would very much appreciate your feedback

- Global filter : “Spendings per month” should not react on global filter, since I want to see the trend over all years. How do I do that?

- Dynamic title:  Please see my solution with Min and Max (Date), however is there a better way to solve it so I can add plain text there?  Such e.g. “Time frame: Jan 2012-Sep 2012”

-Share of advertising:  I would lie to calculate a share and place it in the KPI workbook as just one number: Sum(Euro[for selected brand])/Sum (Euro [all brands]).

Many thanks, Matylda