I am confused.
I've been going round and round trying to create a table that has three colums. Column1 has a number of unique references, column 2 has a list of people, column 3 has a list of thrid party references.
I have been trying for nearly a week now to find a simple way of counting the references per person MINUS the number of third party references per person.
I did a pivot table, but when I try to create an extra colum to calculate, I can't get it to work. It wants to add the column field instead of the count of column.
I've achieved the numbers I want, but it looks very scrappy and when I copy the pivot table to another month tab, it copies the data over and references Januarys tab instead and I can't find a way of forcing it to only look at that tab for its data.
Arrrrgh. Anyone have any ideas?
I've been going round and round trying to create a table that has three colums. Column1 has a number of unique references, column 2 has a list of people, column 3 has a list of thrid party references.
I have been trying for nearly a week now to find a simple way of counting the references per person MINUS the number of third party references per person.
I did a pivot table, but when I try to create an extra colum to calculate, I can't get it to work. It wants to add the column field instead of the count of column.
I've achieved the numbers I want, but it looks very scrappy and when I copy the pivot table to another month tab, it copies the data over and references Januarys tab instead and I can't find a way of forcing it to only look at that tab for its data.
Arrrrgh. Anyone have any ideas?
