the problem is: i can't select or do a click over this expressions to know which user is in each group. I have a workaround but the question is if there is any way to select an expression value.
Have you tried to put an expression or mapping in the data load so that you can easily display handle the "age group" as a dimension (multiple benefits including speed) to see the counts as well as have a drill down or show a details table/straight table?
Sure. I've included some sample inline statements below. Notice first table is your "dimension" a simple way to "group" individual ages into the groups/target audiences you are looking for. You would need to map as many ages as you like and you could use different categories. The "Age" field would automatically be associated between the two tables so that you can easily get to the people in the Age_Group. You can also use the Age_Group and Age as part of a Drill Down group for your application and Chart. Your Chart Expression would be =Count(Name) and would start with the #'s for the groups. But if you clicked on a group you could see the counts by the ages that make up that group. Or you can simply use a Pivot Table instead of a chart that would handle the drill downs. You could see the subtotals for each group, and then click on the + sign in the pivot table to view the people. You could get fancy and use the chart to view the #'s pretty by group, and offer the Fast Change to get down to the people inside the pivot. But using the data model as the place holder for things like this allows you to fire the expression/join 1 time, but refer to the data without CPU costs for the end users.
