Hi All,
I have a data set like this in which the latest Month is Mar-15 (in this example only)>
| Month | Account # | Qty |
| Jan-15 | 101 | 5000 |
| Jan-15 | 102 | 3500 |
| Jan-15 | 103 | 2500 |
| Feb-15 | 201 | 3200 |
| Feb-15 | 202 | 1400 |
| Feb-15 | 203 | 4800 |
| Mar-15 | 301 | 2200 |
| Mar-15 | 302 | 1900 |
| Mar-15 | 303 | 5200 |
I have a text object, which shows a label - 'Data is Current Through - Mar-15' (This value is dynamic and would show the latest month available in the model).
I used ='Data is current through: ' & MaxString({<[Month]=>}[Month].
But the problem is, when any Account# is selected which doesn't belongs to the Mar-15 (or the latest month), the Label changes to show that month belonging to the Account #.
How can I show the latest available month in the model, irrespective of the selections?
