Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have trawled the internet and have tried various different techniques, but nothing seems to work so far
I have 3 months worth of data
Apr 2013
May 2013
Jun 2013
I want to have a button which shows all data for the current month (I have acheived this by) =Date(monthstart(AddMonths(min(breach_test),0)), 'MM-YYYY')
I can also achieve a button to show the next month with the following criteria: =Date(monthstart(AddMonths(min(breach_test),+1) ), 'MM-YYYY')
However I cannot seem to toggle between the 2 buttons.......The Next month button will keep going into Jun 2013. I want the user to choose between the 2 buttons, without having to go through the entire sequence
Any ideas?
Thanks
Helen
Try using min({1}breach_test) instead of min(breach_test), at least for the Current Month expression. You'll have to decide if you want to use it for the other expression too.
Try using min({1}breach_test) instead of min(breach_test), at least for the Current Month expression. You'll have to decide if you want to use it for the other expression too.
Hello
Thank you! This works for me