Waterfall Chart - Measures sorted from largest absolute value - Show real +/- value
I would like to use the Waterfall Chart to display financial deviation per cost categories between budget and actual figures.
I have 18 cost categories named here A to P. The deviation value per cost category can be positive or negative. To have a better picture of what are the main deviations, I need to show the 6 largest deviations (either positive or negative) in the chart and group the rest under one "other" category. Please see the table below which illustrate my need.
What I know: How to find Min, Max, 2nd Min, 2nd Max etc.. Usage of Fabs function. Basically I know how to show the first largest +/- deviation, but I am quickly blocked when I am trying to find the second largest +/- deviation.