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

[Anonymous]

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

[rsbin]

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

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

[DimaMD · Accepted solution]

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

[DimaMD]

Hi @Anonymous Look at the file, everything is simple there