You have to add second dimension
ex if you want to show location wise yearly collection then
use year as first dimension, location as second dimension
and write expression as sum(amount)
this way you will get year on x-axis sum(amount) on y-axis (left side) and location as legends at right side.
if you change the order of dimension then
you get location on x-axis and year as legend at right side.
Thanks Shubhasheesh ,
I did that already but my issue is that I'm not able to see a cont. line connecting diff year it shows me only for one year in chart even though it got value for diff years.
Thanks Raghav, I can not send you d orig. one due to some restrictions but i'm just adding a sample file which got the same problem it got atleast 2 years but my original file showing me only for one year.
pls note m utilizing rank function.