creating a dimension of cumulative values on different level elsewhere

[Anonymous]

Hello,

here is a tough one.

I have calculated a pareto class for customers within a sheet object (which is affected by selection i make):

1, calculated cumulative sales for sorted sales per customer:

RangeSum(Above(Sum(sales), 0, RowNo()))

2. derived pareto clas from this with:

if([Cumulative spend]/sum(total sales)<=0.8,'A',

if([Cumulative spend]/sum(total sales)<=0.95,'B','C'))

-> IS THERE A WAY to create a table showing only A, B, C as dimension and calculating spend, no of customers etc based on the above in another table where that has been done on customer level?

thanks

[sunny_talwar]

If you have more recent version of QlikView, you can def. do it. Look here:

Recipe for a Pareto Analysis – Revisited

[Anonymous]

hello Sunny,

how can i get this to respond to i.e. year selection or any other?

=Aggr(

    If(Rangesum(Above(Sum({1} Sales)/Sum({1} total Sales),1,RowNo()))<0.8, 'A',

        If(Rangesum(Above(Sum({1} Sales)/Sum({1} total Sales),1,RowNo()))<0.9, 'B',

            'C')),

    (Product,(=Sum({1} Sales),Desc))

    )

[sunny_talwar]

May be this:

=Aggr(

    If(Rangesum(Above(Sum({1<Year = p(Year)>} Sales)/Sum({1<Year = p(Year)>} total Sales),1,RowNo()))<0.8, 'A',

        If(Rangesum(Above(Sum({1<Year = p(Year)>} Sales)/Sum({1<Year = p(Year)>} total Sales),1,RowNo()))<0.9, 'B',

            'C')),

    (Product,(=Sum({1} Sales),Desc))

    )

or

=Aggr(

    If(Rangesum(Above(Sum({1<Year = p(Year)>} Sales)/Sum({1<Year = p(Year)>} total Sales),1,RowNo()))<0.8, 'A',

        If(Rangesum(Above(Sum({1<Year = p(Year)>} Sales)/Sum({1<Year = p(Year)>} total Sales),1,RowNo()))<0.9, 'B',

            'C')),

    (Product,(=Sum({1<Year = p(Year)>} Sales),Desc))

     )