excel_1317
Board Regular
- Joined
- Jun 28, 2010
- Messages
- 212
I have thousands of rows like below. I need to make a pivot for below data based on parent name. Now survey count in pivot shows as 48 which is wrong. If i do average, it gives me 7.4 and using max give me 10. But the correct survey count for ABC Corp. is 14(10+4). How can this be achieved in pivot, may be adding a helper column in the data? My solution is to bring 14 as survey count corresponding to ABC corp. in pivot. Excel masters please help
Parent Name | Survey id | Survey Count |
ABC Corp | 0123 | 10 |
ABC Corp | 0123 | 10 |
ABC Corp | ||
ABC Corp | 0123 | 10 |
ABC Corp | 0456 | 4 |
ABC Corp | 0456 | 4 |
ABC Corp | 0456 | 4 |
ABC Corp | 0123 | 10 |