I have a dataset that isn't that clean for Male/Female. It want to seperate
it to M/F/U(nknown)
There are some U's some blanks and some O's in that columns.
How can I filter it so

select {[TotalSubs]} on Columns, CrossJoin([Gender].members, [Age
Group].members) on Rows from [Consumer]


also I'm getting
Gender | Age | Total Subs
M | 25-30 | 100

any way to get a percentage of the total ?


Gender | Age | Total Subs | %
All | | 1000 | 100%
M | 25-30 | 100 | 10%