Jump to content
  • Different ways to organize column data in a worksheet

    PVA - Admin

    There are three different functions to manipulate data in a column:
    -         You can summarize items in a column
    -         You can sort items in a column by descending order


    Notice the three gray icons to the right of the down arrow located right above row 1:



    To activate these icons you must select one of the database rows at the far left of the worksheet. Once these icons are available, click and drag the icon to the desired column header. Notice that the descending icon has been dragged to the A column and the ID numbers have been sorted accordingly.




    Note: Up to three sort icons and three summarize icons can be placed in the columns of a database row.

    Edited by JimW

      Report Article

    User Feedback

    This doesn't work in VW 2016 on a Mac. Even if it did, it's a very odd way to design a sort command. Why not just select what you want to sort, select "sort" from the edit menu, and select the column criteria for the sort. All this icon dragging is not intuitive. Oh, and did I mention that it doesn't work? The icons are always grayed out and do not drag anywhere.

    Link to comment

    You need to first click on a row header (In the above example it would be 2 or 2.1 or 2.2…).  That tells the work sheet which database you want to sort ( you can have many databases in one worksheet).


    Once a row header is selected you drag the sort or sum icon to the column you want to sort or sum.


    I agree, it is a nonintuitive UI.  


    Link to comment

    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.

    Add a comment...

    ×   Pasted as rich text.   Restore formatting

      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.

  • Create New...