Essentially, I want to rank the line charts based on the quick table calculation so that the tables with the biggest fluctuations (+ or -) between just the most recent week and last (26 Dec and 28 Nov) come to the top, while keeping the visualisation as a line chart. If I could keep the quick table calculation displayed just in the tooltip that would be great, but not required.
Many thanks in advance
Shane
(Edit workbook has been updated to TWBX as the data wasn't included in the original)
2 answers
Apologies, rookie mistake. I have it updated now.
Thanks for highlighting that!