You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to easily setup TOP 5 Chart - Doughnut

Received Response
31
Views
1
Comments

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!