Forum Discussion
TREXcel
Feb 07, 2020Copper Contributor
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...
macrordinary
Feb 08, 2020Brass Contributor
Is there a reason why you need the Project Employees and ProjectAllSalaries tables in your model?
Does the model work without these tables?
If you're looking to aggregate by project, what relationship do the projects have to the IDMCT tables? Would there be any way to include the project in these tables and then bypass the Employee List table?