rohitpareek
New Member
- Joined
- Apr 22, 2002
- Messages
- 4
hi!!
I have a pivot table containing data from SQL Server. In the data portion I'm displaying a field containing some integare value. But,Ialso want to display just above this value a field that contains 'comments'for the values in previous field. But when I includethis field in data portion of the table...it makes a summary of that (e.g. Sum,COunt etc.) and doesnt display the text value. AlsoIt displays the by the side of the integer value,but I want it to be displayed over the integer value (in th same col but prev row).
PLEASE HELP!!
I have a pivot table containing data from SQL Server. In the data portion I'm displaying a field containing some integare value. But,Ialso want to display just above this value a field that contains 'comments'for the values in previous field. But when I includethis field in data portion of the table...it makes a summary of that (e.g. Sum,COunt etc.) and doesnt display the text value. AlsoIt displays the by the side of the integer value,but I want it to be displayed over the integer value (in th same col but prev row).
PLEASE HELP!!