Department Head Percentage of total in Formula

[jstoessel]

I have a simple request, but I'm struggling to make it work.

The request: For the incidents closed this fiscal year - I need a Percentage of the total by my breakdown (which is department head)

if I make a doughnut chart, this happens automatically - example here is the 32%

My presentation is to add this as a column in a Pivot table in PAE.  

I feel like this would be a formula indicator "method", but I'm struggling with making this simple and scale able.

The desired visualization will be something like this

Can anyone nudge me into the correct direction to make this work?

[olgaredkina · Accepted solution]

Hi, Pivot table unfortunately doesn't have a % options available automatically, so you are right, only option would be to have formula, so you would have one regular automated indicator with number of incidents and another formula to get % and then you can add both to the pivot table. If you on Xanadu you can use a bar chart with table under, so it will show both number and % in table view. This would be simple and scalable but a bit hidden and not exactly UI you are looking for.