1 of 1 people found this helpful
If you are not showing the date in the chart (for instance, it is NOT a trend chart) you can do the following:
1. Create a calculated field of max(YourDateField)
2. Drag this new calculated field onto the Sheet's Detail
3. Edit the Title of the Sheet (right click on title and choose Edit)
- select from the 'Insert' list on the top-right corner the Max date calculated field
If you are showing a trend chart you need to change the calculated field to us Level of Detail (LOD) and Exclude the date of your Date Field.
See attached example.