Description
I have 5 columns related to demographic data of a single item. Those items are then put into groups based on a status column.
I’ve created a widget dashboard to display the totals of each demographic column with filters for various groups/status.
I want to display those same numbers, but as a percentage of the total sum of those columns. I’ve created the formula column to sum the 5 demographic columns, but I can’t find a way to display percentages either as individual numbers or on a pie chart.
Any suggestions?
What are you trying to achieve
Display percentages of the sum of 1 column out of the total of 5 columns.