Forum Discussion
Data Model & Pivot Table Sums are Aggregate not based on model
Hello, I have built a data model and am trying to summarize my data. Not sure why but each row of my pivot table gives an aggregate sum of all the data rather than the row's information. The Ke...
TREXcel I see very similar behavior when trying to aggregate customer spend from several different sources. I get the 'right' amount for the table the Pivot was originally created from, but the sum of the column for any related tables. Did you ever figure this out?