Unlock a world of possibilities!
now and discover the exclusive benefits awaiting you.
I want a straight table to display values with customized date selection(Like one column will display YTD value and another column will display MTD value).
The date is to be selected from list box. Listbox contains analysis period(Cur Year, Today, MTD). How to achieve this using alternate state?
This doesn't sound related to alternate states at all to me..?
You could set up multiple expressions and have a calculation condition so e.g. the MTD one would only display if MTD was selected, etc.
You could have an if() statement to check what the field's value is and pick a formula accordingly.
Maybe I misunderstood your question...