Hello,

I'm having trouble finding a solution so hoping someone here might be able to help.

My raw data gives me a row per person per week per sales channel.
Name Chnl Date Amount
John Smith A 7/07/17 500
John Smith B 7/07/17 800
John Smith A 7/14/17 100
John Smith B 7/14/17 1,500

My pivot table is showing the data like this

A B
John Smith
7/7 500 800
7/14 100 1,500

I want to add a week over week delta, I'm thinking as a separate column.

A B WoWA WoWB
John Smith
7/7 500 800 - -
7/14 100 1,500 (400) 700

My initial thought was to add a helper column to the raw data but even with that I'm having a little bit of a mental block in how to get the prior week numbers to pull on the same row. I'm thinking that I would have to concatenate a few fields and then do a vlookup, seems a little clunky.

Any thoughts?

As always thank you in advance for any assistance.