-
1. Re: Caption "And n More" issue
Tracy RodgersApr 6, 2012 12:57 PM (in response to P Fro)
1 of 1 people found this helpfulHi Peter,
One possible option if you are using a range you could create a calculated field that will show the Min and Max years. I have attached a screenshot showing this.
Besides this, I don't think there is anyway to have it list out every selection. This might be a good one to place under the Ideas section of the Community.
Hope this helps!
-Tracy
-
2. Re: Caption "And n More" issue
Shawn Wallwork Apr 7, 2012 9:42 AM (in response to P Fro)Peter, you can do this if you're willing to hit it with a hammer. Here's the calc:
You'll need to do one of these for each year you want displayed. (See attached workbook.)
But, Tracy's solution is much more elegant.
--Shawn
PS: Hey Joe I'm actually starting to get the hang of these table calculations .
-
Peter.twbx.zip 1.3 MB
-
-
3. Re: Caption "And n More" issue
Richard Leeke Apr 7, 2012 10:26 PM (in response to Shawn Wallwork)You can use table calculations to build the full list with the help of the PREVIOUS_VALUE() table calculation function, as in the attached example.
-
List all Rows.twbx.zip 1.1 MB
-
-
4. Re: Caption "And n More" issue
P Fro Apr 9, 2012 10:16 AM (in response to P Fro)Great ideas everyone, thanks!