Thank you for the reply.

if the indicators act similar with conditional formating then why the need for percentage values? if we select numeric then indeed it will act as conditional formating based on numeric values; but when percentage is used it should select values based on percentage of that value from the total.

It doesn't work that way.