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