roattw Posted February 7, 2021 Report Share Posted February 7, 2021 I need to count how many times each of 22 categories occurs in a table column. Colum= Major_category I can get the count non blanks as below but I need the resultant counts sorted by magnitude, not by the category sorted alphabetically. Thanks! Quote Link to comment Share on other sites More sharing options...
0 CoopperBackpack Posted February 18, 2021 Report Share Posted February 18, 2021 Hello @roattw, If I understand your inquiry correctly, you want to sort the records by the Count non blank of Major_category field. It is possible if you click on the title name. By default, all results are sorted by the values in the first field (Rows in Pivot). When you click on the title of another field values are sorted in ascending order. When you click once again values are sorted in descending order. Is that what you need? Quote Link to comment Share on other sites More sharing options...
0 cheonsa Posted August 23, 2022 Report Share Posted August 23, 2022 Hello! Just sharing with you this article on how to apply default sorting to a Pivot column: https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/apply-default-sorting-to-a-column-in-pivot-table-datapages/ Quote Link to comment Share on other sites More sharing options...
0 roattw Posted September 17 Author Report Share Posted September 17 I couldnt get this to work actually Quote Link to comment Share on other sites More sharing options...
Question
roattw
I need to count how many times each of 22 categories occurs in a table column.
Colum= Major_category
I can get the count non blanks as below but I need the resultant counts sorted by magnitude, not by the category sorted alphabetically.
Thanks!
Link to comment
Share on other sites
3 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.