Forum Discussion
Displaying two fields on same row
The table below is taking two rows per customer and is showing identical numbers on both rows. That's because it is showing totals per client Number (e.g., 1099) on one row and the same figures...
I thought blank cell is the norm when you prepare any pivot tables. They are set up to give a table based on one field. Whenever you put two fields in rows, it assumes a parent child relationship and starts with totals for the parent, followed by data for each child. In this case, it is assuming client # is the parent and Client name the child. That's why you see blank cells. Again, I think all pivot tables, including in plain Excel, would show results like this.
Satish
oh ok, sorry i didnt notice that this is pivoted data.
Can you show us how the data looks before you do pivot?
Thanks
Raj