How to display a field containing text values just above eac

R

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!!
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
You must log in or register to reply here.

Similar threads

B
  • Question
Getting a pivot table value from VBA Code
Replies
0
Views
159
BenW71
B
F
  • Question
VBA to take a field value from 1 worksheet and update that field value to another worksheet based on another cell value
Replies
4
Views
159
Peter_SSs
Peter_SSs
J
  • Question
Vba code to display the 3 values contained in a specified column in a message box
Replies
1
Views
277
rlv01
R
ajjava
  • Question
Procedure to find MAX VALUE in a SPECIFIC pivot table value field, in the case of MULTIPLE pivot table value fields
Replies
0
Views
839
ajjava
ajjava
A
  • Solved
Comparing two excel files for matching / mismatching rows (long text strings - match() wont work
Replies
4
Views
559
ahaye
A

Forum statistics

Threads
1,215,066
Messages
6,122,948
Members
449,095
Latest member
nmaske

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top