You need to pivot the data so that the age group can be a column. To do this, highlight the columns by shift/cntrl select and right click and select pivot:
By default, your age group column will be named as pivot value field names, and the values as pivot value:
But you can right click and rename:
Now you can use the age group field to use as a filter:
I've attache the workbook for you to review.
Review1.twbx 91.1 KB
You can create a parameter to select which measure you want to display and then a variable that contains the measure selected in the paremeter.
The parameter will look like this:
And the variable like this:
Then in the rows you will have the sum of Select Age group measure instead of each individual measure.
So now, in you can choose from the parameter which measure to visualize:
Hope it helps!
Thanks Eddson for your response. The only problem which I can see is you can only select one age group.
Thanks Mavis for the response. I will try this and update this thread soon.
Yes, the solution of Mavis is integral, mine was a way to use parameters but it takes more time also!
But nice to know that "All roads lead to Rome" hahaha