PivotTable : Unexpected behavior with 2 tables
Hi, The first picture shows the expected behavior of adding 'Product' and 'Revenue' to a pivot table. Now when i add the same fields but from 2 different tables linked with a relationship, the result is different (please see 2nd picture). Could somebody explain this weird behavior ? Thanks in advance PivotTable with 1 table PivotTable with 2 tables Relationship
