on 13 Apr 2017 07:39:13
To do Pareto analysis of data you need to use RankX, Create a cumulative sum of the list (TopN), then divide the cumulative sum at the row by the grand total of the column. the resulting output is the % the running sum is of the grand total. From there you filter to show top x%.
However, couldn't this process streamlined into custom calculation and while we are at it, why not allow the data to be grouped in Quartiles, Quintiles and Deciles.