Hi All,
I have a requirement which i am struggling to implement. I have a list box(Region) with values 'India', 'China' and 'Australia' and another listbox containing 'Month Year' values, like Jan 2016, Feb 2016, March 2016, etc. I bar chart shows sum of sales across all regions where dimension is 'Month Year' field. Right now, i dont have any data for Australia reigion. What i am looking is as below.
1) If a user selects any field value from Region list box and any value from 'Month Year' list box, bar graph will calculate will show the graph accordingly.
2) Now accidently if a user selects 'Australia' as a region, the bar graph should retain previous calculated value(step1) and should not change. (Since i don't have data for australia, so i don't want blank display)
3) again if user selects any other region apart from Australia, graph should calculate and show values accordingly.
I hope i am clear to explain my requirements. Any help is much appreciated.
Regards
Bibhu Sharma
