I have calculated measure that removes negative values. Problem is the Total is summing up incorrectly.
Here the script of the measure.
Create Member currentcube.[Measure].[Amount2]
as iif ([Measure].[Amount]>0, [Measure].[Amount], null)
Below is sample result.
Customer Amount Amount2
A 100 100
C 100 100
D 100 100
E 100 100
View Complete Post