![]() Our Pivot will look as shown in the below snapshot. In case you wish to view the details of the employees based on their location, we will be making a small change in the existing pivot. Drag and drop the Location column under the Rows shelf. The Pivot that is generated now, will contain the data of the employees who were absent. You can choose the columns for which you wish to show the missing values. ![]() In the settings tab that appears, Under the Show Missing Values section, click Choose Columns link next to For columns in the "Rows" shelf. You can either right click on the column name and choose Show Missing Values or click Settings option on the toolbar. To view the name of the employees who were not available for a particular day, you can enable show missing value function for the Employee Name column. This Pivot does not contain any record of the employees who were not available (absent). To do that, drag and drop the Date and Employee Name column in the Rows shelf and Clock-in hours column in the Data shelf. Lets now create a pivot as shown in the below snapshot to view the number of employees present in the given week. In case an employee is not available for a particular day, his data will not be available for that day. Let us say that you are the manager of a team and would like to view your employee`s attendance details every week. With this option, you can choose to display the record even if a point does not contain a value. When creating a Pivot, if a particular data point does not have any value, then the Pivot would skip displaying that data. This can be applied on a Date or a Category column. Show missing values feature is used to display the in-between missing values in a Pivot. By default, this value will not be selected. For columns in the 'Rows' shelf: You can choose to display the filtered columns in the 'Rows' shelf by selecting/deselecting the check box.To learn more about missing values, refer the below section. For columns in the 'Columns' shelf: You can choose to display the filtered columns in the 'Columns' shelf by selecting/deselecting the check box.Show Missing Values: You can choose to display the filtered values from here.Description: You can change the description of your Pivot Table from here.Title: You can edit the title of your Pivot Table from here. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |