Forum Discussion
Excel PivotTable Show Values As feature not working?
Hi experts,
MS365 Excel data file that I have been using for last 5 years to show case how "Show Values As" feature when doing a regular pivot table (not Power Pivot or Data model related) now shows nothing when I try to calculate % of Grand Total. Everything in my Values Field are numbers and I have run this same exact process for years and only Jan 2025 is now just blank. Has anyone run into such an issue? (Microsoft 365 MSO (Version 2502 Build 16.0.18502.20000) 64-bit
I'm not trying to show items with no data! Just trying to use "Show Value As" feature to calculate % of Grand total.
1 Reply
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
