multiple total

Hello,
I need to create multiple total, but can't find the way...
Let say I have data from months: person, payment type, amount.
Report is sorted by months, then payment type - each month has its total(sum) regardless of payment type.
What I need is total(sum) of each payment type at the end of report. If I put another group with footer I have each of payment types multiple times.
Could anyone help me, or show sample of such totals of totals?

Comments

  • edited 11:32AM
    hi,

    idk, maybe im wrong with this, but idk a way do to this natively
    i had the same need some time ago, at the end of the report i need to put a summary of all the data listed on it,
    i attached a example, u can see this feature at page 11 and 12

    but i achieve this with another dataset connected in the report.

    speaking technically, in my application, i opened the original query, read all the rows in it and mounted another
    dataset (the summary) at the end of this process

    that solved my problem.

    hope it helps

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.