Iterations with Totals

From the configuration of the iteration crosstab we may add standard elements, such as a Grand Total:

mceclip0.pngmceclip1.png

Before we print the PDF file from this, we may also want to modify the text header to include some fixed text, “Revenue” in this example, and change the {ProductGroupMembers} dynamic content to work as a Single.

mceclip2.png

From the resulting PDF file, the first four pages would look like this:

mceclip3.pngmceclip4.png

From this, we can conclude that:

  • Including the Grand Total in the iteration crosstab will produce an extra iteration – one with data from all Product Groups in this example.
  • The Single option in dynamic content will insert the dimension member name only if the criteria for the iterated page is based on a single dimension member.
Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.