0 Replies Latest reply: Sep 11, 2014 7:15 AM by Guenter Quistorf RSS

    "Aggr" in a Dimension / ABC-(Pareto-) Analysis

      Second trial, as the first was posted under "ABC-Analysis"; probably seemed not so interesting/attractive

       

      Hi there,

       

      I have one question; I would like to have for a procurement analysis the ABC ranked sums of each category to see the relations between the sum of purchasing value, the actual inventory, the number of SKU's etc.

       

      I found examples for a regular ABC-ranking by e.g. materialnumbers but not as sums per category.

      I understand that mostprobably I have to work with a calculated dimension like this:

       

           =if(aggr(PurchasingValue, MatNo) <= fractile(TOTAL PurchasingValue, 0.8), '-A-',

       

      (and so on....), but in this case the result will give me as category A the first 80% of the material numbers and not the first 80% of the desired purchasing volume.

       

      On the attached excel sheet I demonstrate the result as an example, that I would like to have...