Sort Table in Visma Business: Step-by-Step Guide

Learn how to sort table in Visma Business with the following steps. To sort a table in Visma Business based on a specific column, follow these steps:

Quick sorting in Visma Business

To quickly sort a table in Visma Business, follow these steps:

1. Place the cursor in the column you want to sort.
2. Click on one of the sorting buttons:
   • Sort ascending (A-Z): Sorts from least to greatest (or A-Z).
   • Sort descending (Z-A): Sorts from largest to smallest (or E-A).
3. The sorting is saved until you change it or close the window. To see the current sort, press F7 or click on the Sort button in the Ribbon.

Advanced sorting in Visma Business

When you need to add multiple sorts in Visma Business, do this:

1. First open the Sorting box by pressing F7.
2. Then click on Add.
3. Then choose whether you want to sort ascending (A-Z) or descending (Z-A).
4. Then click on Add to add more sorting.
5. Finally, finish by clicking on OK.

Show total in table in Visma Business

To display a grand total of all rows in your table in Visma Business:

1. First open the Sorting box by pressing F7.
2. Then check the box for Include total.
3. A color-coded row appears at the bottom of the table and totals the columns that can be summed, e.g. Actual Amount Planned (SEK) and Released Number.

Example of how you can sort tables in Visma Business

To sort the Orders table with the oldest orders at the top and then sort by customer number, proceed as follows:

1. Sort order dates A-Z first.
2. Then sort by customer number A-Z.

Good to know

Here are some important notes to keep in mind when sorting tables in Visma Business:

• Wait for the sort: if the table has many rows or links to other tables, sorting may take time. Therefore, you should avoid clicking further until the sorting is complete.
• Sorting limitations: You cannot sort certain columns, such as calculated columns. The sort buttons will be grayed out when you are in these columns.

Vanliga frågor (FAQ)

Question: How do I sort a column in ascending order in Visma Business?

Svar: Placera markören i den kolumn du vill sortera och klicka på knappen Sortera stigande (A-Z) i Ribbon.

Question: How do I add multiple sorts in Visma Business?

Svar: Öppna rutan Sortering genom att trycka på F7. Klicka på Lägg till och välj om du vill sortera stigande eller fallande.. Upprepa för varje ytterligare sortering och klicka sedan på OK.Hur visar jag en totalsumma av alla rader i min tabell i Visma Business.

Fråga: Hur visar jag en totalsumma av alla rader i min tabell i Visma Business?

Svar: Öppna rutan Sortering genom att trycka på F7 och markera rutan för Ta med totalsumma

Q: Why can't I sort certain columns in Visma Business?

Svar: Vissa kolumner kan inte sorteras eftersom de är beräknade. Sorteringsknapparna blir gråmarkerade när du står i dessa kolumner.