Grouping and Adding additonal Total Columns to a Matrix

[Anonymous]

@ links to members, content

I am having trouble breaking out this report as well as adding additonal total columns to a matrix.  Any assistance would be greatly appreciated.  I am using color coding formula I created to distinguish the type of time entered in the timesheet report.

[v-lili6-msft]

hi  @Anonymous 

To my knowledge, it couldn't achieve that add additional total column in matrix for now.

you may try Greg_Deckler's way, but this will need take manual maintenance, and I would suggest you use two matrix to combine them to get it.

Regards,

Lin

[amitchandak]

@Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format?
Appreciate your Kudos.

[Anonymous]

Hint:

@ links to members, content

I am working with time sheet data for employees.  The purpose of this report is to see when a employee has not entered time for a specific date, when time has not been entered, that date will show with pink background.  When time has been entered it will show with a green background.

The issue is in our database employees are placed in a category :

Labor-DLY

Labor-SAL

Labor- HRL

In the matrix as columns I have the workdate and the category.  The matrix lists all categories not just the category the employee actually falls under.  Therefore, if the employee is only Labor-DLY  and the employee enters time for that date, it is green, but the matrix goes on to color Labor -SAL and Labor HRLY with a pink background as if the employee is missing time for these two categories. The employee is not missing time for Labor-SAL and Labor-HRLY because the employee is a Labor-DLY employee.

The excel sheet is the actual report.  Also it totals all at the end of the matrix, in which I need a column for Labor, Vacation and Holiday Totals broken out. 

Hope this helps.  Thank you for any assistance!

[Greg_Deckler]

@Anonymous - I have a technique for this: https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428

[Anonymous]

Greg_Deckler

This looks as if will take manual maintenance.  I need this to be dynamic whenever time is entered.