This content has been marked as final.
Show 3 replies
-
1. Re: Help with dynamic captions
michael.wu Mar 7, 2013 6:26 AM (in response to michael.wu)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
-
2. Re: Help with dynamic captions
Joshua Milligan Mar 7, 2013 6:26 AM (in response to michael.wu)Michael,
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.
E.g.
TOTAL(SUM([Sales]))
Then include that in the level of detail and use it in the Title or Caption instead.
Regards,
Joshua
-
Total Sales.twbx.zip 87.0 KB
-
-
3. Re: Help with dynamic captions
michael.wu Mar 7, 2013 6:32 AM (in response to Joshua Milligan)Thanks! Works great!