Notifications
Clear all
Power Pivot
2
Posts
2
Users
0
Reactions
31
Views
Topic starter
Hello,
I have a 10k+ headcount dashboard very similar to the "Interactive Excel HR Dashboard" created by My Online Training Hub.
Quick question regarding pivots tables created from a data model using month to month files for headcount.
I have employee files for each month so I can get a month over month active headcount. Now, when I'm looking at a pivot table and double click on a number to see the raw data behind that number, I see all of the duplicates and only 1000 rows appear. Is there any way to fix that?
Posted : 12/10/2021 4:26 pm
Hi Jennifer,
Welcome to our forum!
This is a limitation of Power Pivot. However, you can just set up another PivotTable that shows the detailed rows at the same filter level as the report on the dashboard.
Hope that helps.
Mynda
Posted : 12/10/2021 7:32 pm
