Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Do you really need A,B,C and D within a single object? The simplest way to get the result of A,B,C would to select them or to exclude all other values. Another way would be to use conditions within the dimension/expressions to exclude unwanted values like: sum({< dimension1 -= {'D'}>} value).
If it really should be within a single-object you could add within the script another grouping-dimension for dimension1 and apply the partial sums on this dimension. Also possible is to add an additional value of "Total" to your dimension1 and query then this value within the expression like: if(dimension1 = 'Total', expr1, expr2).
I suggest just to use the feature of selecting the wanted values ...
- Marcus