This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have been tasked with taking a data set of 6 Fields and 149 Records and comparing values. Theses are grouped into Bands with different codes in the same bands and a salary value for 4 years. I need to compare each salary to each other salary in the same band and compare these differences year on year. This is going to take me ages. Does anyone know a quick way to do this? Is there an analytic tool i haven't used that can achieve this?
When you say compare them within bands and year on year....what should emerge from it? What ultimately are you wanting the output to be? If you can take one band from your sample data and reference that here, it would be really helpful.
From what i remember from this i appended the main data set to itself to give every possible combination. I then transposed this to give Name Value Groups and then grouped by these. i will try and see if i can find an example workflow later if i have time.