I have a table with 4 columns:
% age group 0-15 = the percentage of people in age 0-15 in this specific area
% age group 16-29 = the percentage of people in age 16-29 in this specific area
% age group 30-44 = the percentage of people in age 30-44 in this specific area
I want to see in my report in witch area I have the younger people and in witch area the oldest people, so I thought of calculating the variance for each column, but I couldn't find a way to do it (I saw only variance for each row).
maybe there is an easier way to show it with colors and not by calculating the variance .
This shouldn't be difficult, can you provide some dummy data please ?