Beast Mode % of the total in Chart
I want to create a calculated value that show the % of the total. I have done this: SUM(Case WHEN `Country` LIKE '%In' then `Value` ELSE 0 END) / SUM(Case WHEN `Country` = 'TotalIns' then `Value` ELSE 0 END) But it displays anything although the formula is correct. I tried using only the first part of the formula and it…