I have a pivot table with Account Number in the "Rows" and Local Currency in the "Values". There are 383 account numbers total in the pivot table but I want the detail for only 171 of them. I have the list of accounts for which I want the detail. Is there a way I can extract the detail from the pivot table for only the accounts I want without having to go one by one?
The pivot table is connected to the system so the detail is not available unless I double click on the account balance I want in the pivot table.