Within SSAS (multidimensional). I've created a bridge table to hold multiple attributes for a given diagnosis. (There can be more than one diagnosis type for a given value).
I get the results to display the correct grand total. However, since I had to use a bridging table, now I get duplicate measure values. I only need to show the first one, the rest can be set to 0. How do I do this via MDX or cube settings? Or is there a workaround I can use?
Current result:
| DiagnosisType | Value |
|---|---|
| Diagnosis 1 | 100 |
| Diagnosis 2 | 100 |
| Diagnosis 3 | 100 |
| Grand Total | 100 |
Desired Result:
| DiagnosisType | Value |
|---|---|
| Diagnosis 1 | 100 |
| Diagnosis 2 | 0 |
| Diagnosis 3 | 0 |
| Grand Total | 100 |