see the attached
there is a table calculation to find the difference
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Example (6).twbx 13.2 KB
Many thanks for the quick reply Jim.
I was playing around with this functionality but I wouldn't want the difference columns repeated for every Date. Either hidden on the first only or else separated out into a 'third' date column only named Variance as per below:
Can you think how to achieve this?
see what ZZ did it will work for you
This is excellent ZZ. Many thanks for your help.
Thanks also Jim for your input.