We have a Pivot Table list of companies in Knack, that is sorted A to Z. But Knack puts companies with a lower case first letter, as in “bp” in the attached screenshot.
Anyone know why Knack does this and is there a workaround to have the company show up correctly in alphabetical order (in this case in “Bs”)? Is this just a quirk of Knack and no way around this, without changing how a company spells its name?
First and foremost, a warm welcome to our community, and thank you for sharing this with us!
Regarding the issue you’ve encountered with your pivot table, there is a known bug associated with sorting when using a connection field. To determine whether this bug is causing the behavior you’re experiencing, we recommend getting in touch with our support team.
You can reach out to our support team through the chat widget in the Builder, or you can submit your query by using this form. They will be more than happy to assist you in diagnosing and resolving the issue.
Thank you for your understanding. Your feedback and involvement are greatly appreciated!
Have a great rest of your week!