QTY Variance

[#1]

Hey guys.

I have a table i need to see the changes in Quantity over a week. I only have a weeks worth of data. This is my current formula:

sum({$<Day={$(=Only()-1)}>}(QtySold))

I set it as an expression as well as sum(QtySold) to show the current days Qty. I have Days as a dimension. The formula given above is not working. Can anyone help on this and maybe supply a variance expression formula also?

Thanks you so much.

[#2]

anyone got any ideas please?

[#3]

anyone at all?

[johnw · Accepted solution]

You can't do it with set analysis because the set is only calculated once for your entire chart, not once per row in your chart.

I recommend handling it with an AsOf table to connect everything together. See attached example for comparing years.

[#5]

Thanks so much man. Im going to look into it today.