I am coming to QlikSense from Qlikview. In Qlikview, I can create a Pivot Table, and then add a column so that I end up with something like this.
+ State | StateAbbrev | | 360,000
| SomeCityOne | 240,000
| SomeCityTwo | 120,000
How can I get the StateAbbrev into a column beside the State column without having some aggregate function? Here is an image of what I am attempting to do. I would like to get the Miles sitting beside the ord_hdrnumber in its own column, but I'm not sure how.