Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
I am trying to plot prices on a line chart so i can see how the price changes over time.
It seems to work with no ref's selected or with a ref selected that only has 1 price attributed to it. for multiple ones it doesnt work.
I dont want to sum it expression as i want the individual prices plotted. can anyone help please?
I have added the frequency to the list box so you can see which have multiple lines.
sample attached
any help is welcomed
try this expression
=Sum(Amount)/Sum(Qty)
are you trying to plot "price" for each "Ref" for "Year & Week"?
You have negative values in Quantity field, is it supposed to happen?
Your Week field, should be sorted by time, correct?
hi,
I am sorting by expression..
negatives are correct.
i am trying to plot price for product (i have not included product in the data, but the user has to select a product for the chart to populate, i have commented out the calculation condition in the chart)
sum(Amount)/sum(Qty) should return what you want