I have a cube with 2 measures
ActivityCount | MissingGender
10 | 2
At backend in fact table it goes like this
ActivityCount | MissingGender
1 | 0
1 | 0
1 | 1
1 | 0
1 | 0
1 | 0
1 | 0
1 | 0
1 | 0
1 | 1
When Drillthrough action defined and used in browser for "ActicityCount" it gives 10 rows back, but, for "MissingGender" it also gives 10 rows, how can I limit it to show on 2 rows where gender is missing?
Is it possible to do it without adding any dimentional filter?
Is it possible to do it wtihout creating a seperate fact table / view for the measure "Missing Gender"?
Thanks