Pareto Graph and the DSum function

[manix]

Hi All,

I currently have a Pareto graph created by a query, that counts occurence and then uses the Dsum function to create the cumalative %. The function is as follows:

CumPct: DSum("[CountofConcern_Number]","qry_ProbByConcern","[CountofConcern_Number]>=" & [Total Concerns] & "")/DSum("[CountofConcern_Number]","qry_ProbByConcern")

This is as per MS article: http://support.microsoft.com/kb/208373

Now this is OK and is as per the MS article but if you have counts that are the same, it just give the same cumalative % for each one that is the same. Please see attached image for an example of what this query produces.

Does anyone know how I can sort this out? TIA

 

[manix]

Not great with VB code but has anyone used VB code to do this? It seems a bit cack handed doing this with lumped together Queries and as you can see above, the DSum function does not accurately replicate cumalative %s.

It seems so simple!!!! Count and sum, work out what each item is in terms of % of the whole, then add these together in decending order (decending order refers to the count, not the %).

Anyone have any ideas?