Week over Week change in pivot table

[trisoldee]

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.

[trisoldee]

to complicate the situation I also have a column that is showing a length of time in HH:MM:SS.

[stasinek]

Give a sample file, it will be easier to work. Show next to how it looks.

[oeldere]

See column H for the result.

You get better and quicker help if you add an excel file with your example.

See the second tab in the value box (amount2).

[trisoldee]

See column H for the result.

You get better and quicker help if you add an excel file with your example.

See the second tab in the value box (amount2).

Thank you, I was going to do that this morning but then saw your post.

So basically I was over complicating the situation and should use the difference from and previous option.

Thank you again.