How to easily setup TOP 5 Chart - Doughnut

Customer need:

The customer wants to visualize the most important cost drivers of the "total costs".

Both the 'Top 5 Cost Drivers' and the sum of all other remaining cost drivers should be presented in a diagram (doughnut).

'Total Cost' is a hierarchical parent of many Level 0 items (various types of costs).

I haven't found any predefined solution (data form/dashboard) that would cover this requirement.

So, I created a data form that not only identifies the top five cost drivers, but also calculates the sum of the remaining cost types.

 

The data form consists of formula columns as well as formula rows to identify the top five cost types (using e.g. RANK() function) and the sum of all other cost drivers.