Hi I have a custom field dimension “GWO Bug Type”, This is multiselect field. This field can have below combination
- “QA Prod” → this has on 2 issues
- “QA Prod” and “Sitecore” → this has on 2 issues
- “QA Prod” and “Conflict”. → this has on 2 issues.
I tried to create calculated member and I can see result which is partially true. In below example at top level number is right 6 bugs in total for this memeber. but when I expand and I can see QA prod having 6 issues which I want to display only 2 and Conflict and Sitecore number is correct.
Could you please help me to achive this?