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...
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
Raj,
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 |