Jump to content
  • 0

Sort by pivot table calcualted field value? Why is counting field occurrences so hard....


roattw
 Share

Question

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.   

count.thumb.jpg.d108fd3bcfe6a14bf5634605d4c7c514.jpg

 

Thanks!

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

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.
PSFuGGQ.png

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? 

Link to comment
Share on other sites

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.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...