Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Grouping and Adding additonal Total Columns to a Matrix

@ 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.

5 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

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

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago
      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!
  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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