Power Pivot Table - Show Details

jeancake

Board Regular
Joined
Nov 3, 2008
Messages
54
I noticed that when i create a power pivot table and click on the totals to show the details it's limited to 1000 rows. Is there a way to display all the records like I would in a regular pivot table?
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

GraH

Well-known Member
Joined
Mar 22, 2020
Messages
598
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
It actually makes sence there is a limitation on the drill down. PP can hold much more data then a sheet can. It allows to view a sample only.
You can set it to the max number of rows of a sheet though in the connection properties, section OLAP drill through.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,741
Messages
5,524,560
Members
409,584
Latest member
Devil_717

This Week's Hot Topics

Top