Page History

...

Visual Analytics offers the following types of Table Calculations

• Difference From
• % From
• % Difference From
• Running Total
• % Of Total
• Moving Calculation
• Rank
• Percentile

Table Calculations default to [Difference From] if no other option is chosen when they are created.

...

1. Right-click a measure.
2. Click Table Calculation Templates > select the desired calculation type.
   
   
   The chart view will display the applied table calculation. If you want to change the calculation type, repeat steps 1 & 2.
3. To change the calculation definition, repeat steps 1 & 2, and then select the desired calculation definition from the drop-down.
   
4. Hover the mouse on the cell, to view summarized values in a tooltip.
   

   This  is displayed for the fields to which table calculations have been applied.

Table Across calculations perform their calculations from left to right across a table within a row. In the example below, green circles indicate values used in the [% of Total - Table Across] table calculation for SUM(Freight). Red squares indicate the results of the table calculation.

...

(1) In the first row, the red box around -93.59 for Difference in SUM(Freight) was arrived at by using the following calculation:
15.01 - 108.6
where 108.6 is the SUM(Freight) for the previous item (Bib-Shorts/On Promotion for Currency Code AUD and Card Type ColonialVoice) on this row.

(2) In the fifth row, the red box around -153.8 was arrived at by using the following calculation:
514.37 - 668.17
where 668.17 is the total of all Bib-Shorts/On Promotion for Currency Code AUD and all Card Types.

(3) In the last row of the table, the red box around -307.12 was arrived at by using the following calculation:
538.71 - 845.83
where 845.83 is the Grand Total of all Bib-Shorts/On Promotion for both Currency Codes and all Card Types.
 
(4) In the Bike Racks/Price column, the red box around -35.8 was arrived at by using the following calculation:
25.28 - 61.08
where 61.08 is the SUM(Freight) for the previous item (Bike Racks/On Promotion for the Currency Code CAD and Card Type SuperiorCard) on this row.

(5) In the last row of the table, the red box around -802.38 was arrived at by using the following calculation:
336.33 - 1138.71
where 1138.71 is the SUM(Freight) of all Bike Racks/On Promotion for both Currency Codes and all Card Types.

...

(1) In the first row, the red box around -86.179% for % Difference in SUM(Freight) was arrived at by using the following calculation:
15.01 - 108.6 = -93.59
-93.59 / 108.6 = -86.179%
where 108.6 is the SUM(Freight) for the previous item (Bib-Shorts/On Promotion for Currency Code AUD and Card Type ColonialVoice) on this row.

(2) In the fifth row, the red box around -23.018% was arrived at by using the following calculation:
514.37 - 668.17 = -153.8
-153.8 / 668.17 = -23.018%
where 668.17 is the total of all Bib-Shorts/On Promotion for Currency Code AUD and all Card Types.

(3) In the seventh row of the table, the red box around -100% was arrived at by using the following calculation:
0 - 111.67 = -111.67
-111.67 / 111.67 = -100%
where 0 is the SUM(Freight) of all Bib-Shorts/On Promotion for Currency Code CAD and Card Type AUD.
 
(4) In the final row within Bike Racks/Price column, the red box around -70.464% was arrived at by using the following calculation:
336.33 - 1138.71 = -802.38
-802.38 / 1138.71 = -70.464%
where 1138.71 is the SUM(Freight) for the previous item (Bike Racks/On Promotion for all Currency Codes and all Card Types).

...

(1) In the first row, the red box around 62 for Moving Average of SUM(Freight) along Sales Reason was arrived at by using the following calculation:
109 + 15 / 2
where 109 is the SUM(Freight) for the previous item (Bib-Shorts/On Promotion for Currency Code AUD and Card Type ColonialVoice) on this row. The 2 is used in the calculation because we have selected the Average function, and there are 2 values.

(2) In the fifth row, the red box around 591 was arrived at by using the following calculation:
668 + 514 / 2
where 668 is the total of all Bib-Shorts/On Promotion for Currency Code AUD and all Card Types.  The 2 is used in the calculation because we have selected the Average function, and there are 2 values.

(3) In the last row of the table, the red box around 692 was arrived at by using the following calculation:
846 + 539 / 2
where 846 is the Grand Total of all Bib-Shorts/On Promotion for both Currency Codes and all Card Types.  The 2 is used in the calculation because we have selected the Average function, and there are 2 values.
 
(4) In the Bike Racks/Price column, the red box around 43 was arrived at by using the following calculation:
61 + 25 / 2
where 61 is the SUM(Freight) for the previous item (Bike Racks/On Promotion for the Currency Code CAD and Card Type SuperiorCard) on this row.  The 2 is used in the calculation because we have selected the Average function, and there are 2 values.

(5) In the last row of the table, the red box around 2860 was arrived at by using the following calculation:
1385 + 1475 / 2
where 1385 is the Grand Total of all Bib Shorts/On Promotion for both Currency Codes and all Card Types. The 2 is used in the calculation because we have selected the Average function, and there are 2 values.

...

(1) In the first row, the red box around 123 for Moving Average of SUM(Freight) along Sales Reason was arrived at by using the following calculation:
108.6 + 15.01
where 108.6 is the Running SUM(Freight) for the previous item (Bib-Shorts/On Promotion for Currency Code AUD and Card Type ColonialVoice) on this row. 

(2) In the first row still inside the Bike Racks/Price column, the red box around 603.2 was arrived at by using the following calculation:
512.58 + 90.62
where 512.58 is the Running Total of all Bike Racks/On Promotion for Currency Code AUD and Card Type ColonialVoice.  

(3) In the third row of the table, the red box around 645.17 was arrived at by using the following calculation:
305.8 + 339.37
where 305.8 is the Running Total of all Bib-Shorts Sales Reasons for both Currency Code AUD and Card Type SuperiorCard.  
 
(4) In the eighth row, Bike Racks Total column, the red box around 105.36 was arrived at by using the following calculation:
19 + 86.36
where 19 is the Total SUM(Freight) for all Bib-Shorts Sales Reasons for the Currency Code CAD and Card Type SuperiorCard on this row.

(5) In the last row of the table, the red box around 2859.58 was arrived at by using the following calculation:
1384.54 + 1475.04
where 1384.54 is the Grand Total of all Bib Shorts/On Promotion for both Currency Codes and all Card Types. 

...

(6) In the Grand Total row, the red box around 1 for Rank was arrived because it is the only value in the Grand Total row for the Bike Racks On Promotion column. 1139 is the only and highest value on this row and column (Total and Grand Total rows are not included in the column rankings).

...