Multiple labels(?) on scatter plot data point

[#1]

Hi all.

I am currently working on a dashboard to visualize some data. The data points are laid in specific x,y coordinated in the scatter plot with the technique described here Re: make static map with scatter chart. With my dimension, I am able to show individual values (i.e. the dimension as label on the data point)

I am also able to show multiple individual values with '&&', given the values are not aggregated.

My data look something like this:

data1:

lab1	lab2	lab3
28	11	26
29	63	74
30	18	90

data2:

lab1	lab4
28	2
28	3
29	5
29	15
30	3
30	21
30	20

My question is, how am I able to aggregate the lab4 from data2 (sum up all lab4 belonging to the same lab1) and show it on the label in the scatter plot? e.g.:

Thank you in advance.

Jenkins