Producing the data for an Excel distribution graph 1

[mikelawrence]

I want to produce a graph of what % of people produce what % of revenue, e.g. the top 20% of people contribute 50% of revenue type of thing. I'll produce the graph itself in Excel but have now realised i am slightly clueless as to a good way of producing the data to run the graph from. Any ideas?

Thanks

Mike

 

[vongrunt]

Two running totals (count, sum) over result set sorted descending. (ORDER BY revenue DESC).

AFAIK this can be also done with raw data and Excel pivot report/chart (paperclip included ).

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)