Forum Discussion
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
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
- DimaMD
Solution Sage
- rsbin
Community 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,
- AnonymousNot applicable
I was hoping to find a way to calculate it into a table instead of a visual
- DimaMD
Solution Sage
Anonymous HI, You can perform the following actions
1 It is necessary to write 2 measures
2 Create a spreadsheet
See attached file