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
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