Forum Discussion
Solved
Pivot Not Grouping
Hello Experts, I am trying to group a simple data set. I have 2 Columns: Deposits and Withdrawals I need to Group on SWAP. It doesnt group for some reason. Do you see why its not gro...
The problem is that some of the "SWAP " have a space after the word and others do not
I did a Find & Replace to remove the extra space and refresh the table and it worked perfectly:
If creating PivotTable you add data to data model (if you are on Windows)
texts will be trimmed automatically while loading to data model, thus no additional actions are required
Nice tip. thank you!