I have time dimesion group (Day-Week-month-quarter-year) called T1. I am using T1 Group on the X-axis to chart the number of defects (per day/ per week / per month.......)
I am trying to display the latest T1 value in the caption of the chart like "defects up to 2009-11-22" when using T1 as Day or like "defects up to FY2010-Q3" when using T1 as Quarter.
simply I am trying to find out how to extract the max T1. I have tried simple Max(T1) expression and did not work.
What part isn't working? What are you seeing? Because I just tried...
='Data Through ' & max("Date Group")
... as the caption for one of my charts, and it worked just fine for me except for a minor problem. When displaying by quarters, it displayed the numeric value of the underlying date instead of something like 'Q4 09', but that could be addressed with conditional formatting or something based on the getcurrentfield("Date Group"). Not sure if that's a problem you're having though. I'm guessing that "did not work" means you're seeing nothing?
I am assuming that you are actually selecting an item of the time group then it gets displayed. but in my case I do not want to selelct one item of the time group , I want to display them on the X-axis with the ability to display the last date item in the caption.
I have tried your max and still not working (getting NULL).
