Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pivot table showing text
Check out this link...
http://www.contextures.com/xlfaqPivot.html#Text -- HTH... Jim Thomlinson "ryguy7272" wrote: I've gotten it to work with text. If you double-click the items that you want to put in the Pivot Table (it's called 'Show Field List'), all items will be entered into the 'Row' area. Everything cascades down based on the first item in the 'Show Field List'. Change to suit your needs. Regards, Ryan--- -- RyGuy "Jim Thomlinson" wrote: Pivot tables do not work with Text... -- HTH... Jim Thomlinson "geebee" wrote: hi, i would like to know if there is a way to show a pivot table showing text values instead of sums and counts. i have a a data sheet which only contains text. i was thinking of using a VLOOKUP tat contained multiple AND/OR, but i cant figure that out either. can someone help? thanks in advance, geebee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
### showing up in pivot table. | Excel Discussion (Misc queries) | |||
Showing all rows in a pivot table | Excel Discussion (Misc queries) | |||
Value not showing in pivot table | Excel Discussion (Misc queries) | |||
Showing Pivot Table total on Associated Pivot Chart | Excel Discussion (Misc queries) | |||
Pivot table showing #N/A | Excel Programming |