Percent of total for a calculated field

[Aditya_Raj]

So I have parameter as filter, where in I select the KPI from the dropdown and the same KPI populates in the table below. Now right it is giving me absolute value. What if I want to calculate percent of column total how do I do that ? Like instead of absolute value i want % of column total. Please find below the calcualted field formula also.
select KPI =
ifelse(
…

${KPI} = ‘GMS’,sum(gms),0)

[Wakana]

hi @Aditya_Raj ,

there is percentOfTotal() provided in QuickSight. instead of doing just sum(), you can try using this function ?

percentOfTotal - Amazon QuickSight

kind regards,
Wakana