alethea2000
Board Regular
- Joined
- Nov 27, 2003
- Messages
- 67
I have this data source
CAM 004 will always have overpayment of housing benefit in the next column
So I want my pivot table to display for example CAM004 in one column The Words Overpayment of housing benefit in the next column next to CAM004 and then sum the figures. All it seems to do is to count or sum The Words Overpayment but I want the text. If I put DEC type as a row then it appears under CAM004. is there a way of doing this please
CAM 004 will always have overpayment of housing benefit in the next column
So I want my pivot table to display for example CAM004 in one column The Words Overpayment of housing benefit in the next column next to CAM004 and then sum the figures. All it seems to do is to count or sum The Words Overpayment but I want the text. If I put DEC type as a row then it appears under CAM004. is there a way of doing this please