Just to add an example.. I use something like this...
The total # of items sold is <SUM(SOLD)>. But, it comes out like
The total # of items sold is 25 to 100
That seems to be the default way the Title / Caption works. It seem to take the minimum and maximum values in the entire view (including what shows in the Grand Total) and uses them. You can get around that, by creating a calculated field using the TOTAL table calculation.
Then include that in the level of detail and use it in the Title or Caption instead.
Total Sales.twbx.zip 87.0 KB
Thanks! Works great!