how to dynamically change the chart?

[#1]

Hi all

i have dimensions country,region,state,year,month.

first chart show the country wise sales.after with out user selection chart show region ,month,year wise sales.automatically it will change the dimension  .how?

[#2]

Hi

you can create cyclic group(Year,month) or drilldown(Country,region, state) group .Then you can use the these group as dimension in chart and

in expression tab write the expression.

Regards

tripati

[sunny_talwar]

Without selection? Not sure I understand your requirement completely. Would you be able to elaborate? May be you are looking for Cycle Group???

Creating Cycle and Drill Groups

[swuehl]

If you are looking for some kind of slide show, time triggered change of the charts shown,  have a look at my answer here:

Re: Dynamic Chart Swapping

[MarcoWedel]

Hi,

one solution might be:

Dimension:

=Pick(Floor(fmod(Now()*86400/vInterval,5)+1),country,region,state,year,month)

Expression:

=Sum(sales)+0*Now()

hope this helps

regards

Marco