• Different ways to organize column data in a worksheet


    JimW

    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:

    4-1.gif

     

    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.

     

    4-2.gif

     

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

    Edited by JimW

    0




    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.

    0

    Share this comment


    Link to comment
    Share on other sites

    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.  

     

    0

    Share this comment


    Link to comment
    Share on other sites


    Create an account or sign in to comment

    You need to be a member in order to leave a comment

    Create an account

    Sign up for a new account in our community. It's easy!


    Register a new account

    Sign in

    Already have an account? Sign in here.


    Sign In Now