We have an expense report where it will list the total amount of each expense type per report and we also have a column which shows the overall total amount of the entire report. We would like to just have the total amount appear once so when we total all the reports by employee, it sums just the total report amount.
To better explain i have attached a sample output. As you can see there are 2 expenses (meals and taxi) each with their amounts from the report but then the Total Report Amount shows the sum of the meals and taxi amounts but twice so if i try to sum at the employee level, it will add the 124 to itself thus doubling the report. How can i just have the 124 show once based on my groupings we can see the totals of each expense type on a given report and the total report.
Quote from: gats1527 on 02 Jan 2018 09:25:52 AM
We have an expense report where it will list the total amount of each expense type per report and we also have a column which shows the overall total amount of the entire report. We would like to just have the total amount appear once so when we total all the reports by employee, it sums just the total report amount.
To better explain i have attached a sample output. As you can see there are 2 expenses (meals and taxi) each with their amounts from the report but then the Total Report Amount shows the sum of the meals and taxi amounts but twice so if i try to sum at the employee level, it will add the 124 to itself thus doubling the report. How can i just have the 124 show once based on my groupings we can see the totals of each expense type on a given report and the total report.
There is a group span property that allows you to specify the group that an item should visually span although you could just simply add a summary row so that the approved amount is totaled for each group and overall for the report across multiple employees.
can you explain more on the summary row you mentioned.
Quote from: gats1527 on 02 Jan 2018 10:09:08 AM
can you explain more on the summary row you mentioned.
Check out chapter 10 in the user guide. Basically just click on your metric in the list and then click the summarize button. It will automatically create an overall footer with the total as well as a sub-total for every grouping level. You can remove ones you don't want.
https://www.ibm.com/support/knowledgecenter/en/SSMR4U_10.1.0/com.ibm.swg.ba.cognos.ug_cr_rptstd.10.1.0.doc/t_cr_rptstd_wrkdat_agg_bttn_dim.html