Hi
I have excel worksheet which has about 50+ columns of different error types, error1, error2, error3,….till 50+ and at the end it has total field, total correct fields, Accuracy, Month and week. In single worksheet I have 1000+ transaction.
E.g
Transaction, Error1, Error2, Error3, Error4……………………… Week Month
2013-123456 1 1 0 1 Week1 Jul 2013
2013-123457 1 0 1 1 Week2 Jul 2013
2013-123458 0 0 1 1 Week3 Jul 2013
2013-123457 1 1 0 0 Week4 Jul 2013
2013-231456 0 1 1 1 Week1 Aug 2013
2013-231748 1 0 1 1 Week2 Aug 2013
2013-123457 0 1 1 0 Week3 Aug 2013
2013-124578 1 1 0 1 Week4 Aug 2013
I want to get count of 0 from each error type by using pivot table with Report Filter as Week and Month
E.g
Month Jul-13
Week All
Error Type 0 1 Grand Total
Error1 1 3 4
Error2 2 2 4
……..so and so forth
When I am trying pivot table, where I select Report filter as Month, Week, Row Label as All Error Types and Values as Count of Error1, Count of Error2, Count of Error3…….so and so forth, it gives me following result which does not indicate which unique count for each error types.
Row Labels Count of Error 1 Count of Error 2 Count of Error 3
0 4 4 4
1 4 4 4
0 1 1 1
1 3 3 3
1 13 13 13
0 3 3 3
1 3 3 3
1 10 10 10
0 3 3 3
1 7 7 7
Grand Total 17 17 17
Please help me to solve these issues
Regards
Gopinath
Bookmarks