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?
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
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