Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Summarize data by column 1 and filter/categorize by another column

Hello, 

 

I would like to summarize the values of one column (hours) based on the value of another column (User) filtered and categorized by another column (category).  See table below for details

 

Current Sheet                                          >>>> Wanted Result

User         Category      Hours                                                      User           Cat. A Hours Cat. B hours
User 1        Cat. A             1                                                          User 1             5               6
User 1        Cat. A             4                                                          User 2             1             11
User 1        Cat. B             6                                                          User 3              11            6
User 2        Cat. A             1                                                          User 4             6               6
User 2        Cat. B             5                                                          User 5             2               8
User 2        Cat. B             6
User 3        Cat. B             6
User 3        Cat. A             9
User 3        Cat. A             2
User 4        Cat. A             4
User 4        Cat. B             6
User 4        Cat. A             2
User 5        Cat. A             2
User 5        Cat. B             2
User 5        Cat. B             6

  • DimaMD's avatar
    DimaMD
    3 years ago

    Anonymous HI, You can perform the following actions
    1 It is necessary to write 2 measures
    2 Create a spreadsheet
    See attached file


4 Replies

  • rsbin's avatar
    rsbin
    Icon for Community Champion rankCommunity Champion

    Anonymous ,

    Your Current Sheet is set up correctly.

    What you simply need to do is create a Matrix Visual.

    Bring User into Rows, Category into Columns, and Hours into the Values well (Ensure Sum is selected).

    Then format the Matrix to your liking.

    Hope this helps and Regards,

    • Anonymous's avatar
      Anonymous
      Not applicable

      I was hoping to find a way to calculate it into a table instead of a visual

      • DimaMD's avatar
        DimaMD
        Icon for Solution Sage rankSolution Sage

        Anonymous HI, You can perform the following actions
        1 It is necessary to write 2 measures
        2 Create a spreadsheet
        See attached file