| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display repeating data in Pivot Tab
Hello,
I have a Pivot Table which displays 3 fields. By defaults, Excel groups the data and removes the repeating data. For example, I have the following: CustId Account# Balance 1 A1 200 1 A2 300 2 A3 400 Excel displays this as, CustId Account# Balance 1 A1 200 A2 300 2 A3 400 Note that it doesn't display CustId in the 2nd row. But I want it to display it. How can I do this? Thanks Vasan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I display the actual data in the data field of a pivot chart? | Excel Discussion (Misc queries) | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Macro to search for and display data in another worksheet | Excel Worksheet Functions | |||
| Pivot Table - max rows allowed in data range | Excel Discussion (Misc queries) | |||
| create one pivot from mulitple data sources | Excel Discussion (Misc queries) | |||
Threaded Mode
