How would I go about creating a pie chart out of the following data:
The end result I would like to achieve is a pie chart with 1/3 showing "A", 1/6" showing B, C, D, E.
I've taken your table as initial source, but I had to remodel it to get outcome you expect:
Try attached app.
use a crosstable load to get one field you can use as dimension
hope this helps
You could use the Crosstable or you could concat both the fields into one
Retrieving data ...