I am trying to create a heat map view, initially was successful as below image:
However when more projects are adding in, they have a different data as you can see below. is there a way that I can create a calculated member to merge “1” and “1-extremly unlikely (<10%)” into column or row as “1” only?
For example, define a new calculated member in Risk_impact dimension to group values “2” and “2 - Minor scope reduction &/or Minor impact”:
[Risk_impact].[2 - Minor scope reduction &/or Minor impact]