OK - I created a packaged workbook that I hope will explain my question better.
As you can see, North Carolina office supplies field has the lowest profit ratio z-score at -6.77237.
The North Carolina technology field is blank, however. Only down towards the bottom of the table do you see this score - -0.79885.
I would like to see both of these values for North Carolina (and all states) on the same row, sorted by the first column, or whatever column I choose. I'm fairly certain I need to use the index function (Rank)...but cannot figure out how to do this.
1 of 1 people found this helpful
The reason you are getting the view you are is because of the "Profit ratio z-score" field on the rows. Because this is discrete, the values in the table are on the row that matches. This means (as you saw), that the technology field cannot be on the same line, as it does not have the score of -6.77237 needed to be on that row.
The simplest solution is just to remove the "Profit ratio z-score" field from rows. The view is then what you want, and can be sorted however you wish