6 Replies Latest reply on Aug 8, 2018 10:25 AM by Shinichiro Murakami

# WoW Δ for last two week end dates

Hi,

I need some help with this particular calculation, I have 6 weeks worth of data broken down by a "Week End Date" calc field. I am basically looking at what % of "Total Transactions" are of "Y type". For this I have a calc field - "Ratio". Now when I flip this to a Table Calc > difference from. It gives me the variance wrt prior week. What I actually want is the change in this ratio for just last two "week end dates", and ranked by this change in Descending order.

Attached workbook (2018.1) and spreadsheet with more information, I'd be grateful if you can point me to any related references.

UPDATE:

I have tried few things but nothing seem to work and I really need help with this. Let me know if my explanation wasn't clear enough. Desperately mentioning,

Thank you,

Shiva.

Message was edited by: Toby Erkson -- Mentions removed.

• ###### 1. Re: WoW Δ for last two week end dates

Please do not mention people in the opening post.  Please read this guide from Getting Started in the Forums@Menton Etiquette Guide

• ###### 2. Re: WoW Δ for last two week end dates

Hi Toby,

Yes, I have read these instructions. However, this is a 4 days old post that I just revived letting community know I am still looking for help. And as I stated in my "update" it was a desperate call to mention you all. Sorry for confusion.

Thanks,

Shiva.

• ###### 3. Re: WoW Δ for last two week end dates

HI ShivaRam

Hope this helps.

Define last two weeks.

Thanks,

Shin

1 of 1 people found this helpful
• ###### 4. Re: WoW Δ for last two week end dates

Hi,

Maybe this helps:

[WoW Δ] is addressed to your dates (or across table in this setup) and [Rank Δ] - if you need it explicitly - to the other two dimensions retaining the inner [WoW Δ] addressing as is.

Cheers,

Łukasz

• ###### 5. Re: WoW Δ for last two week end dates

Thank you Shin. Exactly what I'm looking for. Never lost hope on the community.

Best,

Shiva.

• ###### 6. Re: WoW Δ for last two week end dates

Hi Lukasz,

Thanks for looking into this, although your solution is close to what I had previously, your approach is simple and interesting.  Thank you again.

Best,

Shiva.

• ###### 7. Re: WoW Δ for last two week end dates

HI Shiva,

You are very welcome.

Sometimes, because of timing, the post is overlooked, you can add "anyone?" or something to make it refreshed.

Thanks,

Shin.