Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I'm using MS Query/SQL to pull data from a database that holds accounting
information. I have a column (fee) that represents a payment that was made, so, obviously, the number is negative. In SQL, I can change the code to multiply the column by -1 (-1*fee)to make the data positive and everything works fine. However, when I refresh the data in my spreadsheet, it takes that field and moves it to the last column. Do Pivot Tables in Excel expect the columns in a certain order, or does it only look for a matching header, regardless of location? If the former is the case, how to I get Excel to keep the columns in the same order as the columns in my SQL query? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why is the order of my data table opposite from graph? | Charts and Charting in Excel | |||
changing proportion of chart and data table | Charts and Charting in Excel | |||
multiple or changing colours in a data table on an excel chart fo. | Charts and Charting in Excel | |||
create space in line chart between points, linked to pivot table | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel |