Cant get the percentage of the total!!!
Hi All I'm trying to calculate the percentage of a column (that is aggregated) using this beastmode (SUM(CASE WHEN `Cluster` = 'Greater North' THEN `Uno` Else 0 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? Thanks