Showing Percent of Total on Matrix Report

Forum|Forum|2 years ago
April 11, 2023
2 replies
1160 views

Is there any way to show the % of a Total on a matrix report? For instance (see example image), if I have total planned hours by program, can I show the % of the total for each program? Getting the total planned hours for the program is easy enough, but I haven't been able to find a way to include a percentage.

Workfront

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by Kundanism

@j_mas

Give a try in matrix settings while editing report;

KundanismAccepted solution

Level 10

@j_mas

Give a try in matrix settings while editing report;

J_MasAuthor

Level 5

Hey @kundanism , in my (admittedly brief) experience with the Show Value Column button, having it turned on in the Matrix Settings just gives me a column with the name of the value already being displayed (not an actual value). So in my above screenshot, if I turn on Show Value Column, I end up with a new column called Value between Program: Name and Project: Aligned Group that just displays the words "Planned Hours (Sum)" for every row. Are you implying that I should be able to use that setting to somehow see a percentage instead?

Kundanism

Level 10

Just an idea @j_mas , cannot we create a custom field which can convert hours in to percent. I haven't tried yet but thinking in this drection too.

Rafal_Bainie

Community Advisor

I would risk saying that if all programs are part of the same portfolio, than maybe you can setup calculated field on program level that would calculate that %of total value.
it can definitely be done if you think of requests/task VS total in a project.

I don't work with programs that much so I'm not sure

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded