laying out data for google charts

[jordan gibson]

Hi

Im trying to add a pie chart to my solution (not the one attached that just an example for on here)

I need to to be able to layout the data in rows and im gettign confused on how to do it without hard coding anything. My example has cities and numbers I want to be able to create two variables that looks like the following

birmingham|Manchester|Bristol

and say

10|80|10

Where the first is just the unique values from that field and the second is the totals from the number field. I guess it has to be a loop of sorts to make sure both line up correctly but i dont know how how to do this in a calculation.

If anyone is bored and could show me that would be great.

Cheers Jordan

pie_chart.zip

[comment]

How about this way?

pie_chart.fp7.zip