I have created a card that displays total population of universities with respect to its ACT value. I want to create a card like below,
I have created a beast mode calculation to determine the percentage in each of its series. My beast mode calculation,
Case when `Public/Private`='Public' then sum(`Undergraduate Population`) when `Public/Private`='Private' then sum(`Undergraduate Population`) else 0 end / sum(`Undergraduate Population`)
This gave me a chart something like below,
I could not get the total by getting sum(`Undergraduate Population`) - it divides based on the University type - Public/Private
It would be fine helpful if someone could help me get the Total value - sum of population from both private and public. Thanks in advance !