I have sales data for W1, W2,...,W8, i need to calculate % sales growth for the latest week i.e. W8/Avg (W1,W2,...W7).
Thanks Gysbert for your quick response.
I need to calculate the % sales growth.
i.e. Week8 sales/Avg(W1 sales,..... to...W7 sales)
QlikCommunity Tip: How to get answers to your post?
( (W8-w7)/W7 )*100
if you want latest week over 2nd latest week
Retrieving data ...