• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel 2010: Double-Click PivotTable Item without Displaying Excess Records

Data Bender

Data Bender

New Member
Thank you for reviewing my post.

When double-clicking a PivotTable value, how does one limit the records displayed?

For example, it makes intuitive sense to see only one record, when double-clicking the value of 1 in the following PivotTable:

pivottable-prescreenings.png


However, I get the following nine records instead:

pivottable-doubleclick.png


The desired result, of only the one record displayed, would appear as follows:

pivottable-doubleclick-goal.png


One more thing.... The file may not have macros, because many end-users view the reports on Macs.
frown.png


I look forward to your help.

Sincerely,
--Data Bender

P.S. I posted this question on another forum, and met a dead-end.

http://www.mrexcel.com/forum/excel-...e-item-without-displaying-excess-records.html

I hope the geniuses at chandoo.org will prevail. :)
 
Welcome to the forum,
I appreciate your link for cross-posted location..

Did you tried to Double click on the cell contain (1)

pivottable-prescreenings.png


I guess, you are talking about, Double click, and view data, from where this record come, and display the result in a new sheet,
and you are not talking about Expand (+) feature, which will expand the collapse table..
try to double click on (1)
 
Thank you for your reply, Debraj.

You are correct. When I double-click the 1, the new sheet shows all nine records pertaining to "Software-Defined Storage Architect," instead of the one record we would expect.
 
Can you please upload sample file..
YES, please delete or change to some random data, for all sensitive data. sample means sample..

coz, just a blind guess, those Offset Pending, and pre-screening, are not part of pivot, :confused:
 
Hi, Data Bender!
Numeric data:
=RANDBETWEEN(min,max)
=ROW()*10000+COLUMN()
Text data:
=CHAR(MOD(ROW(),256))
=REPT(<same_as_above>,MOD(ROW(),100)+1)
...
and the list continues.
Regards!
 
bobhc said:
Use Access, Excel is not the be all
Click to expand...

Great idea, bobhc. I agree. However, as I mentioned, many end-users view the reports on Macs. So, Access is even less of an option. Moreover, Parallels and Fusion aren't options either.

Thank you anyway.
 
Good day data Bender

I do understand the cross platform problems and in built functions in the latest version not working in Access version 1.0 (1992)...;) But the way round that ,which worked for me was to email the reports in PDF to those on the list....:D
 
bobhc said:
...email the reports in PDF to those on the list....:D
Click to expand...

Another great idea, bobhc. Thank you.

How would I activate the filter and click-through features on a PDF file? Multiple end-users customize the above PivotTable with filters, then drill down to the individual record via the double-click feature.
 
Debraj said:
Can you please upload sample file..
YES, please delete or change to some random data, for all sensitive data. sample means sample..

coz, just a blind guess, those Offset Pending, and pre-screening, are not part of pivot, :confused:
Click to expand...

Hi, Debraj.

Thanks again for offering to help.

The attached is a sanitized version of the above spreadsheet.

I look forward to your feedback.

--Data Bender
 

Attachments

You must log in or register to reply here.
Back
Top