see the attached
I was able to get the values you want - but it will result in a line on each of the country charts
this is the calculation
it is computed as shown
then at the difference level
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.
Running_Sum (1).twbx 2.2 MB
In real it is a customer of mine who wants to compare their own sales to the two most aggressive competitors (number of sold items). They buy the numbers from an external service.
It was no problem at all to continue fiddle around with labels, colors or new charts.
I could use the formula you wrote to build exactly what I wanted (almost)!
The only thing I could improve is the scale on the diff. In my mind the scale should be the same as in the real numbers. Here is an image of the result.
I attache the workbook again with new sheet.
Great thanks Jim!
Running_Sum.twbx 2.2 MB