Custom Calculation in dashboard Charts

Hi Team,

I want the Ratio of First and Second column values in the third column in the below given chart.

The calculation is happening for the rows perfectly but due to the default summing up of the column values functionality of charts in creatio , The Ratio is not getting calculated. Ideally for the Final result, the ratio of 1,211,599.69 to 1,040,218.78 should be 1.164 instead of 18,128.5.

Kindly help me getting the correct result.

Thanks,

Sarika