Tag Archives: subtotal

Subtotal on top in VI 10

Hello there,

Today let’s talk about a quick tip: “How to move the grid subtotal to top in Visual Insight 10”.

In version 9.x we couldn’t display the subtotal on top but in version 10 it is quite simple.

To change the subtotal position you just have to:

  1. Click on the header of a column and select Subtotal. Choose the proper subtotal that fits your needs;
  2. Scroll the grid all the way down until you see the total and then right click on it and select “Move to top”;

 

pic1

 

I hope it helps.

God bless you!

Custom subtotal names

Hello there!

Today let’s talk about a good tip of how to change and place wildcards in custom subtotal names.

To create a custom subtotal, you just have to:

1. Edit a report;

2. Click on Data -> Subtotal;

pic

3. Click on Advanced button and click on the New button;

pic

pic

4. Change the name of the subtotal. You add one of these wildcards:

#A - The name of the attribute where the subtotal is displayed
#P - The name of the attribute at the left or above where the subtotal is displayed  
#0 - All forms of the parent's element
#1 - The first attribute form of the parent's attribute from left to the right from top to the bottom
#2 - The second attribute form of the parent's attribute from left to the right from top to the bottom
#3 - The third attribute form of the parent's attribute from left to the right from top to the bottom
#4 - The fourth attribute form of the parent's attribute from left to the right from top to the bottom

One example would be something like:

Subtotal of #1

Hope it helps!

God bless you!