Need help to create multilayer donut chart

Hello ,

I need help creating a multi-layer donut chart with the following specifications:

• Inner Layer: Represents the actual numbers.
• Outer Layer: Represents colors based on the outcome (Red, Green, Yellow).

The logic for the colors is as follows:

• Green: If the goal is higher than actual
• Red: goal is lower than actual.
• Yellow: If the actual number is in between the high and low thresholds.

I have data for both the actual values and goals, and I'd like the outer layer to display only the respective color based on the comparison outcome.

Looking forward to your suggestions!

Attaching the sample report Sample Report , please help