Forum Discussion
Require assistance with Excel Pivot Table
Hi ,
I have some troubles with Excel. The filter in Pivot table is showing double but when i check my source it has no double. The Trim function in Power Query does not work either.
6 Replies
PivotTables by default will retain unique filter items unless you turn it off here (Set to 'None'):
Hi HansVogelaar ,
I am not able to replicate this using another excel file. However, i can show you here or maybe via a Teams/Zoom call if it is fine with you?
Sorry, no.
Could i attach the screenshot(s) of the issue i am facing though?
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?
