Multiple Totals on the Matrix data region

Question

Multiple Totals on the Matrix data region

Trybbe

Hall of Fame

Points: 3967
More actions
June 18, 2009 at 5:58 am

#211081

Hi
I have a headcount report that look like so:
Permanent Temp Contractors Payroll - Vacancies Non-Payroll Vac Total
Marketing 10 4 3 17 10 44
Accounting 3 2 1 6 2 14
HR 2 1 0 3 1 7
Total 15 7 4 26 13 65
I would like to add two calculated subtotals to this matrix :
Totalheadcount = perm + temp + contract
TotalVacancies = payroll vac + non payroll vac
and the grand total would be sum(totalheadcount + totalvalues)
any ideas please assist
Kind Regards

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Randy-574768 Ten Centuries Points: 1385 More actions · Answer 1

Hi
I have a headcount report that look like so:
Permanent Temp Contractors Payroll - Vacancies Non-Payroll Vac Total
Marketing 10 4 3 17 10 44
Accounting 3 2 1 6 2 14
HR 2 1 0 3 1 7
Total 15 7 4 26 13 65
I would like to add two calculated subtotals to this matrix :
Totalheadcount = perm + temp + contract
TotalVacancies = payroll vac + non payroll vac
and the grand total would be sum(totalheadcount + totalvalues)

Have you checked out runningvalues? They will keep a running count over the group that you select for the last parameter.

They work like this:

= runningvalues (fields!perm.Value, Sum, [Grouping])

Randy

Trybbe Hall of Fame Points: 3967 More actions · Answer 2

Hi Randy

Thanks for the feedback.

I would like to have those totals next tothe related fields. e.g

Totalheadcount should be next to contractors then we'll have vacancies followed by TotalVacancies and GrandTotal next to that.