Hey Manavalan,

I have updated the OML based on your inputs.Please check and let me know if you want something else.

Thanks & Regards,

Sudip Pal

Hi @Suprio Roy ,

Thanks for the response. I have only one aggregate table like below. I have one drop down in the page supplier. i need to get % of following

1. First time in page load need % of Total Approved, Pending Approved, Auto Approved

2.  If user click dropdown and filter by supplier for EX: If i filter supplier 1 , i need % of % of Total Approved, Pending Approved, Auto Approved 

Hope it will clear 

Have you tried my solution?

Thanks & Regards,

Sudip Pal

Sudips solution works with pagination. If you do not have pagination you can easily calculate the percentages in an OnAfterResponse action. Just have 3 calculations, one for each state and you have what you need. 

But again, Sudip solution is more robust. Use that one.

Hi Sudip ,

Thanks for the reply. In above your solution working only on change drop down. Not in first time load 

So, on the first-time scenario what should be the desired outcome?

Thanks ,

Sudip Pal

Hi Supia,

Need to Show % of all Supplier  Total Approved, Pending Approved, Auto Approved Ex:

 Total record 12 

In approval 4

Need to show Total approval =(4/12)*100 =33% 

Use the below filter in GetValues instead of the previous one.

Supplier.Supplier=Supplierlist or Supplierlist=""

Thanks & Regards,

Sudip Pal

Thanks its works