Forum Discussion

ctedesco3307's avatar
ctedesco3307
Icon for Resolver II rankResolver II
4 years ago
Solved

Custom calc in matrix total

Hi all - is there any way to get a custom calc in the the total row of a matrix visual? I need this visual to include the people in the list who don't have any values.    For example, the  77.17% u...
Need Help
ctedesco3307's avatar
ctedesco3307
Icon for Resolver II rankResolver II
4 years ago

Looking for some more specific assistance with the ideas referenced above

Below is a lnk to my sample data that I believe has all the categories required, but I'm stuck on how to put them together to get the right average I need. 

 

Workhours is how many hours the employee is available during the day
Bill hours is the amount of time the employee spent on that issue Key 
Util is the % of time they worked that was billable

Util is a measure

Util =DIVIDE ( SUM ( worklogs[BillHours] ), [WorkHours] ) - which works except for the overall as mentioned above.  Link is shareable upon request. All help welcome and thank you very much in advance.
 
 
v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, ctedesco3307 

Have you tried the solution provided by PaulDBrown to change the total value?

You can refer to these silmilar threads.

Matrix-total-subtotal-row-customization 

Totals and Subtotals in Matrix 

For some reason I can't download your sample. If the problem isn't solved, please share your sample data and expected result in Excel for further research.

 

Best Regards,
Community Support Team _ Eason