1 of 1 people found this helpful
There is likely a better way to do it,
but I tried using an LOD calculation to sum across the years,
and then divided each age group by that total.
You could also pivot all the years into one column:
Year AgeGroup Value
2010 >25 ......
And then you should be able to use the Percentage of Column function.
I did thought about the method you employed in Age distribution2, but I did not know how to do the calculated field correctly. Now thanks to you, I do.
And I tried to understand what you did in Age distribution3, but I haven't a clue.
Anyways, thank you very much. I will keep at it.
I've cleaned up the twbx and attached it here.
Apologies if you've seen this before, and apologies for listing each step, but what I did was:
-go to the Data Source tab,
-ctrl-click to select all the age group columns
-select pivot from the pull-down menu
-renamed the resulting columns to AgeGroup, Values
-put Year (as discrete) on the Columns shelf
-put Values on the Rows shelf
-from top menu, selected "Percentage of > Column"
Age distribution4.twbx 23.5 KB