barchart exp

[d_koti24]

I have requirement like bar chart should display sales of latest year sales(by default).But the

year goes to next year if data is get changed then it should be automatically get changed. client

no need to come to us for changing date .So I want data to be year to be changed dynamically,

suppose I have sent you biggest year is 2011. So by default I want that.

Check the screen shot and find Data source.

[sundarakumar]

this can be done with set analysis

sum({<year={$(=max(year))}>}sales)

Reagrds,

Sundar

[#3]

HI,

Try this,

Sum({<Year = {'$(=Max(Year))'}>} Sales)

If the max year would not be change even you do filter on date filed then try the below.

Sum({1<Year = {'$(=Max(Year))'}>} Sales)

[d_koti24]

Thank u boss