Forum Discussion

Copper Contributor

Oct 29, 2019

, Excel Pivot Table not showing 'Show Detail'

Hi First time poster, so happy for any feedback about my post and any help is greatly appreciated. I've happily being drilling into my data within Excel Pivot Tables, however for no apparent...

excel

Wyn Hopkins

MVP

Oct 31, 2019

Hi

Could you add a screenshot of you Pivot Table Fields

Are you drilling down in a Pivot Table or a Pivot Chart?

P_J_Lycett
Copper Contributor
Oct 31, 2019
Wyn Hopkins Thanks for the response Wyn

I can 'double click' into a pivot table and it will show the data and is a work around at the moment.

It's the pivot chart i'm having the issue with.

I've added screenshots of the data (removing confidential info) - i had to do it over 2 screenshots
- Wyn Hopkins
  MVP
  Oct 31, 2019
  Hi P_J_Lycett
  
  This sounds like a BUG, I've responded here... and will flag up with the Excel Team. Please click on File > Feedback and send a Frown
  
  https://answers.microsoft.com/en-us/msoffice/forum/all/office-365-excel-unable-to-select-pivot-chart-show/4747ff11-5ec0-43cb-aa96-82629a4ed01d?page=2&rtAction=1572516647735&tm=1572516825659
  - P_J_Lycett
    Copper Contributor
    Oct 31, 2019
    Wyn Hopkins
    
    Thanks again Wyn, I've attached a screenshot and sent in a 'Frown' to Microsoft
- Wyn Hopkins
  MVP
  Oct 31, 2019
  Sorry P_J_Lycett
  
  I meant a screenshot like this