9 Replies Latest reply on Sep 2, 2018 2:37 PM by Shinichiro Murakami

# Add year on year comparison to QoQ analysis

Trying to include a YoY or  QoQ parameter in current quarter on quarter worksheet -  not sure if it can be done  or requires separate worksheet.?

• ###### 1. Re: Add year on year comparison to QoQ analysis

Hi John,

Not exactly sure, but looks working?

Thanks,

Shin

2 of 2 people found this helpful
• ###### 2. Re: Add year on year comparison to QoQ analysis

Thanks Shin,

Column shelf calc calculation should also change from (ZN(SUM()) - LOOKUP(ZN(SUM()), -1)) / ABS(LOOKUP(ZN(SUM()), -1)) to

(ZN(SUM()) - LOOKUP(ZN(SUM()), -4)) / ABS(LOOKUP(ZN(SUM()), -4))

When YoY selected – i.e. comparison with same quarter in previous year.

• ###### 3. Re: Add year on year comparison to QoQ analysis

Oh, I forgot one thing.

Try this one instead.

Thanks,

Shin

• ###### 4. Re: Add year on year comparison to QoQ analysis

Hi Shin

YoY % are not correct.

Eg When you add type and filter by product ‘X’  the YoY for  CompanyACountry5 should be  +1.9%  and it is showing -30.36%?

QoQ is correct

Thanks

• ###### 5. Re: Add year on year comparison to QoQ analysis

???

Adding other dimension makes question completely different.

Could you please clarify your expectation first.

Table calc is VERY fragile, one dimension change the structure completely.

Even you'd better post new thread only for that, because the technique and approach is very different from original question..

Shin

• ###### 6. Re: Add year on year comparison to QoQ analysis

Apologies for confusion – ignore the additional dimension – not the key issue.

Is there any way to combine the QQ and YY into a single parameter so that users have to select only 2 options.

Thanks

• ###### 7. Re: Add year on year comparison to QoQ analysis

I read thru your comment again and found my misinterpretation of YoY.

If that's the case, the solution is much much easier.

Thanks,

Shin

• ###### 8. Re: Add year on year comparison to QoQ analysis

Excellent – thank you so much – really elegant solution

John

• ###### 9. Re: Add year on year comparison to QoQ analysis

Hi John

You are welcome.

Shin