help with chart

[hopkinsc]

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

[kiranmanoharrode]

try this expression

=Sum(Amount)/Sum(Qty)

[phaneendra_kunc]

are you trying to plot "price" for each "Ref" for "Year & Week"?

[Clever_Anjos]

You have negative values in Quantity field, is it supposed to happen?

[Clever_Anjos]

Your Week field, should be sorted by time, correct?

[hopkinsc]

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)

[Clever_Anjos]

sum(Amount)/sum(Qty) should return what you want