Compare 2 top 20 Pivot Tables

[gmazza76]

Hello,

I have a Top 20 pivot table based on daily data for the current week on sales, but would like to know (if at all possible) if I can show say on Tuesdays table if the sale of "orange" has moved up or down the top 20 from the previous day with a visual indicator (up, down or the same) and if possible the difference in sales.

I have done this before but via a formula basis on in a normal table.

this may seem a bit simple to be honest.

thanks