You question is not clear to me, let me tell you what i understand below is your data as per table.
Location Sales Balance
Newyork 1000 -500
You want the format as below
If this is what you want, then you have to create a Pivot Table ,and place columns as below
Rows Section -- Measure Labels Only
Columsn Section -- No Columns
Measure Section - Location , Sales , Balance
Now you will see the location as null, change the Aggregation Rule to First which will display the result.However this is not recommended because you are using dimension column in Measures and might not work always.
Please mark if helpful.