Cant get the percentage of the total!!!
I'm trying to calculate the percentage of a column (that is aggregated) using this beastmode
(SUM(CASE WHEN `Cluster` = 'Greater North' THEN `Uno`
END)) /Sum(`Uno`) *100
However, in the table it shows "100" although in the Total it does have the right percentage!! (sse pic)
What I am doing wrong?