How to get Count of each Column value of table?

Pivot table

• QUESTION: Hello I am workin as date entry. I will explain my question with an example. I have a table, and i make pivot table Customer # Job Card # Decoder # 1 101 19783351 2 102 19783352 3 103 19783353 Pivot table Row Lable Customer # Job Card # count of Decoder # 1 101 1 2 102 1 3 103 1 i want to count my decoder. All value show same not change in 1. How i can count my decoder without change valuse Best regard ANSWER: I don't understand. You are shown a count of the Decoder. If your input were 1 101 19783351 1 101 19783351 2 102 19783352 3 103 19783353 then your output would be 1 101 2 2 102 1 3 103 1 I'm not sure what you're looking for. The pivot table is giving the correct answer. ---------- FOLLOW-UP ---------- QUESTION: Hello My input is in Table. My output is in pivot table, I just want 3rd column pivot table show like this 19783351 19783351 19783352 19783353 Result come 4 Automatically Best Regard Khurram ANSWER: You need to put the 3rd column in as a row field, not a value field. ---------- FOLLOW-UP ---------- QUESTION: Hello O.K i put my third column in Row Field.My question is how i can calculate my number of decoder. How many decoder i fix. Piviot table give me answer 4. Best Regard Khurram I have a table of data in which each row represents a date-stamped record for a login failure for which the date and user ID is captured each time a user has a login failure. I want to create a pivot table that will show me the roster of users that have had at least one failure spanning each of the dates within the table. I also want to be able to identify the number of times a user had a login failure across the dates, but I don't want to know the number of times the failure occurred. For instance, let's say that user A had one failure on Nov 1 and two failures on Nov 2, while user B had one failure on Nov 2 and again on Nov 3. I would like to see a pivot table in which user A and user B are displayed. Under the "grand total" for Nov 1, there should be 1, while the value for Nov 2 would be 2 and Nov 3 would be 1. Also, the "grand total" for user A and user B would both equal 2. I have set a flag equal to the number 1 at the end of each record, thinking that this would enable me to average while summing the averages within the pivot table. Unfortunately, I either get a table of all ones or a count of total failures by user by date. How can I do this with a pivot table? Please ensure me, why we insert pivot tables and how should we do that? Thanks in advance, loganathan.K My question is this: I like to format my Pivot Tables with colors manually, as opposed to using the templates provided. The problem is, however, that whenever I refresh the table it seems to reset the format (all or part of it) back to blank. Is there any way to prevent this from happening?

• Answer:

  This: Row Label Customer # Job Card # Decoder count of Decoder # 1 101 19783351 2 2 102 19783352 1 3 103 19273353 1 Is what the result should look like. If it doesn't, feel free to send me a sample wb to [email protected], use subject of "AllExpertsQ" and repeat the issue. why not send me a sample data set with the above explanation and what version ofyou have. I can see what I can come up with and provide a recommendation. Also, if you can select a user that is typical and tell me what you would expect the result to look like. (put it in the workbook) Pivot tables are used to work with large bodies of data (count, sum, average). To start a pivot table: 1. Select "Data" from the main menu 2. Select "Pivot table and Pivot Chart Report..." from the drop down menu This will open up a popup menu. Follow the directions from there. If you would like to apply color manually, every time you refresh the color will be gone. To fix this you have two ways: 1. Create a macro with desire color codes to be applied on Pivot table and run it every time the data is refreshed. 2. Create your own Pivot Table Template Click the PivotTable report. On the Design tab, in the PivotTable Styles group, do the following: Click a visible style, scroll through the gallery, or to see all of the available styles, click the More button at the bottom of the scroll bar. Optionally, if you have displayed all of the available styles and you want to create your own custom PivotTable report style, click New PivotTable Style at the bottom of the gallery to display the New PivotTable Style dialog box. Note: Although you can delete only a custom PivotTable report style, you can remove any PivotTable report style so that it is no longer applied to the data. 3. Also, browse through this link: http://www.advanced-excel.com/format_pivot_table.html Ariful