pie chart to show top "x" results as a proportion of total

[#1]

Hi,

I'm working on creating a stock reporting dashboard and want to show the top 500 items as a proportion of the total - both in a pie chart and a table.  However I seem to have hit a wall and am unable to create anything.  Anyones enlightenment would be much appreciated.

Many thanks in advance.

C

[#2 · Accepted solution]

Solution attached

[#3]

Awesome!  Thanks a lot lakhina007