Percent of total for a calculated field

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 =

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

hi @Aditya_Raj ,

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

kind regards,

1 Like