Now we faced the challenge as below, for the same dimension expression and same measure expression in straight table and pivot table, the measure value was not not matched. The straight table value was correct, Do you know any differnt between them? Also any advice how to check the issue here? Thanks in advance.
Pivot table takes into account dimensions, meaning data will be grouped and calculated by dimensions while straight table doesn't. You can read more from here.
