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
|