with set a as order(product.product.children,[Internet Sales Amount],bdesc)--отсортированный список продуктов
member b as rank(product.product.currentmember,a)--ранг продукта в номенклатуре
member c as sum(head(a,b),[Internet Sales Amount])--нарастающий итог
member d as b/a.count,format="percent"---процент от количества номенклатуры 
member e as c/sum(a,[Internet Sales Amount]),format="percent"--процент кумулятивной суммы в общих продажах
member f as case when d<=0.2 and e<=0.5 then'A'when d<=0.6 and e<=0.85 then'B'else'C'end---АБЦ классификация
select{[Internet Sales Amount],b,c,d,e,f}on 0,a on 1from[Adventure Works]

with set a as order(nonempty(product.product.children,[Internet Sales Amount]),[Internet Sales Amount],bdesc)--отсортированный список продуктов
member b as a.count--количество продуктов в наборе
member c as(product.product.parent,b)--кеширование количества
member d as rank(product.product.currentmember,a)--ранг продукта в номенклатуре
member e as sum(head(a,d),[Internet Sales Amount])--нарастающий итог
member f as d/c,format="percent"--процент от количества номенклатуры 
member g as sum(a,[Internet Sales Amount])--общий итог
member h as (product.product.parent,g)--кэширование общего итога
member i as e/h,format="percent"--процент кумулятивной суммы в общих продажах
member j as case when f<=0.2and i<=0.5then'A'when f<=0.6and i<=0.85then'B'else'C'end---ABC классификация
select{[Internet Sales Amount],d,e,f,i,j}on 0,a on 1from[Adventure Works]--конечный запрос