Knowee
Questions
Features
Study Tools

Now I want to see just the total number of times each monster has been killed. How do I do that?Columns: Players, MonstersValues: Sum of KillsRows: Players, MonstersValues: Sum of KillsColumns: MonstersValues: Sum of KillsColumns: PlayersRows: MonstersValues: Sum of Kills1 pointMonsters as Rows; Kills as Values.Monsters as Rows, Players as Columns, Kills as Values.Kills as Columns; Players as Filters; Monsters as Values.Players as Columns, Monsters as Filters, Rooms as Values.

Question

Now I want to see just the total number of times each monster has been killed. How do I do that?Columns: Players, MonstersValues: Sum of KillsRows: Players, MonstersValues: Sum of KillsColumns: MonstersValues: Sum of KillsColumns: PlayersRows: MonstersValues: Sum of Kills1 pointMonsters as Rows; Kills as Values.Monsters as Rows, Players as Columns, Kills as Values.Kills as Columns; Players as Filters; Monsters as Values.Players as Columns, Monsters as Filters, Rooms as Values.

...expand
🧐 Not the exact question you are looking for?Go ask a question

Solution

To see the total number of times each monster has been killed, you would need to set up your data as follows:

  1. Set 'Monsters' as Rows. This will list all the different monsters in your data.
  2. Set 'Kills' as Values. This will calculate the total number of times each monster has been killed.

This setup will give you a table where each row represents a different monster and the corresponding value represents the total number of times that monster has been killed.

This problem has been solved

Similar Questions

Question 3Which of the following methods would enable me to show the Count instead of the Sum of Total?(Multiple answers are possible. Partial credit will be awarded)1 pointRight-click on any cell under the Sum of Total field and go to Show Values As and choose Count.Right-click on any cell under the Sum of Total field, go to Summarize Values By and change it to Count.Drag a text field into Values area and remove the Total field.Right-click on any cell in the Sum of Total field and going to Value Field Settings and under Summarise Values By, find Count.

how to count in excel use noRows

how to find total number of rows having data in an Excel Workbook across all worksheets

Total Spent per Category: Write a query to find the total amount you spent in each category (Groceries, Entertainment, etc.). Hint: Use GROUP BY category and SUM(amount).

Here are the numbers of times 8 people ate out last month.4, 3, 6, 6, 6, 7, 7, 7Find the modes of this data set.If there is more than one mode, write them separated by commas.If there is no mode, click on "No mode." No mode

1/1

Upgrade your grade with Knowee

Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.