How do I show both a numerical display and a trend on the same report?
I'm trying to design a set of KPI numerical displays (each at a point in time) with a 12 month trend line underneath. The first attached screenshot shows what I'm after ("Total Assets" on the far left).
Setting up the trend lines has been straightforward. The Data section of the Report Builder is shown in the second attached screenshot - it's a simple crosstab.
The point-in-time value I want to show for each KPI is simply the last row in the crosstab - the value at the most recent date. However, I can't figure out how to retrieve just that last result for a numerical display.
Is this even possible? If not, if I built the point-in-time numerical displays as a separate report, is it possible to overlay that report on top of the trend line report? Or is there a better approach I should consider?