Pivot table data source order

Sunclipse

New Member
Joined
Aug 31, 2006
Messages
13
Hi all,

I'm wondering if there is a way of checking the source data in the order it lists it in a pivot table.

I am trying to delete rows of information based on realizations ive come to using a pivot table. I can't figure out how to have the soure data show up in the same order so I can delete the right data without having to search through all 50,000 rows.

Thanks for the help!
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
Make sure "Enable Drilldown" is selected in the pivottable properties. (To check, right click on the table, select "table options". If it is checked, you should be able to double click on the result you want to check. The data that feeds into that result will be copied to a new worksheet that you can then look over. However, to delete the data, you will still need to find it in the original data set (maybe by using MATCH or VLOOKUP), and change it there. You will then need to refresh the pivot table to see the impact of the changes.
 
Upvote 0

Forum statistics

Threads
1,218,746
Messages
6,144,266
Members
450,533
Latest member
xoxo1998

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top