Is it possible to have two different pie charts: one to show the percentage of Medium (i.e. photography/ drawing/ painting) and then another pie chart to show the % of the work owned by an artist? Do you have to have two layouts?
A chart is an object, not a layout. You can have as many as you like (given space constraints) on any given layout.
The data in the second chart is not summarized properly though and i did the sort by artist and secondarily by medium. How could I show these 2 pie charts and have both summarized properly?
The charts are doing exactly what you told them to do. Since all records under artist are sorted together, the summaries work. However, you have multiple instances of each medium, therefore, you get multiple pie slices.
To fix it, you can do a couple of things:
1) Use a self-joining relationship and summarize medium based on that.
2) Assemble a list of media in the current found set (probably using a ListOf summary field). Then, loop over it and use GetSummary ( ) to assemble a corresponding list of values to use for your data series.
But basically, you can't use the found set directly on a secondary sort. The summaries split based on the sort order.
Retrieving data ...