I'm currently loading in a bunch of mock-up data from an excel file, a series of clients and their volumes, and the associated rank. What I want to do is sum the volume im getting from the database and see where it would rank if it were part of the mocked up data from the spreadsheet. I cant seem to work out a way that makes sense, anyone got any ideas?
I'm trying to do it with set analysis, by setting the name of the static data volume field to the normal data volume field, and then doing a rank with a selection of static data, but then its excluding the real volume, how can I put the data from one column among another set of data?
