Pareto Analysis(Drill Down)

adamgaox — Thu, 04 Dec 2014 08:40:28 GMT

Hi All,

I've met a problem.

I've got a sales table

For example:

they'll order by Cost,then divide the 1000 people into 10 groups:

GROUP1 SUM(COST)

GROUP2 SUM(COST)

GROUP3 SUM(COST)

GROUP4 SUM(COST)

GROUP5 SUM(COST)

...

GROUP10 SUM(COST)

FOR furthur I can drill down to GROUP 1 THEN 100 people will be divided into

10 groups each group contains 10 people,again and again.

How can I achieve this function?

Thanks in advance.

Re: Pareto Analysis(Drill Down)

mato32188 — Thu, 04 Dec 2014 08:53:16 GMT

Hi "MrBlack",

see attached file, hope could help.