How to Create a Ring Chart with Expense Percentages Based on Total Income?

Hi everyone,

I need some help with creating a ring chart. I want to display only the expenses data, but the percentages should be calculated based on the total income, not the total expenses.

Here's an example of my data:

1.png

How can I create a ring chart that correctly shows the "Personnel expenses" as 30.00% and "Rent" as 10.00% based on the total income of 100,000.00?

AugustoMoro_1-1720562756112.png

AugustoMoro_0-1720562651849.png

Link to my Sheet 

Thanks in advance for your help!

 

 

0 3 339