Forum Discussion
Displaying two fields on same row
Hi
Quick QN : When you say client # and client name are in 1:1 relation, How you are getting blank value in Client# and client name columns?
For row1, why client name is not displaying along with client# ?
Thanks
Raj
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
RajRaj,
I should have made it clearer in my request.
Data files look like the one below. There are mutiple files, one per month. The Power Query combines all of them and that's what feeds the final Pivot Table that I have in my request. Thanks.
Total 1-Aug DR-1099 7138 Client A 1/1/1990 -81,670.58 1-Aug DR-1307 7295 Client B 1/1/1990 739.26 1-Aug DR-1308 7549 Client C 1/1/1990 2,681.58