Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
use set analysis with 1 (represents the full set of all the records in the application)
{1}
use set analysis with 1 (represents the full set of all the records in the application)
{1}
This is Perfect!
Many thanks Massimo.