Pareto class as dimension

[ali_hijazi]

Hello

I'm trying to have the pareto class as dimension using the class function

the calculated dimension i'm using is like this:

=class(aggr(RangeSum(Above(($(vNetSales)), 1, RowNo())) / ($(vTotal_NetSales)),ItemDesc1),0.8)

the expression RangeSum(Above(($(vNetSales)), 1, RowNo())) / ($(vTotal_NetSales))

is for the exclusive percentage as per the following article (Recipe for a Pareto Analysis)

Followin the above article I got the following:

using the class function I got the following:

I got 5 items whose exclusive percentage between 0.8 and 1.6 but actually on the first table the items are 6 under class A

I really got lost

please advise

[sunny_talwar]

I think the issue you are running into is the sorting which is done by load order (because you are using Aggr() function in your dimension). See if this thread offers any solution: ABC Analysis in Qlikview