Forum Discussion
Power Pivot Connection Issue
Hello everyone,
Recently I have prepared an Excel file with 2 different tables. One is the Headcount Table which has the agent information. The other one is the login data for those and many other agents. I added these two tables into the datamodel and connected them with the column that contains the Agent Usernames. Then I added a Power Pivot from the database and added the login data to the values to see the login durations. Then I add the agent names from the Headcount Table to the rows section of the pivot. Every agent name that I have on the HC table appears but for some reason the duration shows me the total duration of the all agents for each agent. I'm sure I did everything correct because I have some other files with the same exact way but for some reason this one is not working properly. Instead of giving me the login duration for each agent itself, it is showing me the grand total for each agent.
Below you can see the grand total is the same as all the agents because for some reason its directly taking the total for the agents as well.
1 Reply
That's usually happens if no relationship or many site field is used in PivotTable. Better if you share if not file when screenshot of Power Pivot diagram view with relationship(s) and PivotTable right pane which shows which fields are used.
