Current month

[#1]

Hello again.....

I have a bar chart with a selection box to click and view data for each month

JAN, FEB etc.

Can I make the chart display the current months results as a default

until the user makes a month selection ?

[Chanty4u]

u can use bookmark for that.

[avinashelite]

yes you can try like this .

If(getselectedcount(field_name)=0 and field_name=month(today()), field_name,field_name)

[sunny_talwar]

May be like this:

If(GetSelectedCount(Month) = 0, Sum({<Month = {"=Num(Month) = Max(TOTAL Month)"}>}Sales), Sum(Sales))

[oscar_ortiz]

To go along with what @Avinash R and sunindia‌ were saying I like to store my Current Month as a variable then use the variable in my expression.  I think it makes for an easier expression.

[johnw]

If the user can only look at one month at a time, maybe set up the list box that way, and select the current month by default using a trigger when they open the application. That affects the whole application, of course, not just one bar chart.