Current date button

[#1]

Hello All,

i have a set of sales data, from the year 2000 to current date. I would like to have a butto/shortcut which by default displays the current year sales.

Regards.

[Anonymous]

Try this

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

[sunny_talwar]

I think you missed the dollar sign

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

[santiago_respane]

You can achieve that by:

• adding a button
• add a trigger that selects the desired value in the desired field
• your expressions can be like:
  • for max year (may or may not current year)
    • =MAX(YEAR)
  • for current year (may or may not have values to display)
    • =YEAR(TODAY(1))

Please let me know if this helps.

Kind regards,