Hi everyone,
The two following formulas are used in a pivot table (Pivot table in default state) and usually give the same result. But, as soon as there is no possible value e.g. in Field1 due to other selections (without an active selection in Field1), the respective values are not summed up in formula 2.
To detail the example: Field1 could be the name of a sales representative that is only used in certain business units. By choosing one of the other business units Field1 has no possible value.
Formula 1:
= Sum({$}Sales)
Formula 2:
= Sum({<Field1=[$]::Field1,
Field2=[$]::Field2,
Field3=[$]::Field3,
Field4=[$]::Field4>}Sales)
Does anyone see a mistake I've done or could this be a bug?
Thanks for your help!
