Page History
...
Visual Analytics offers the following types of Table Calculations
Table of Contents |
---|
...
(1) In the first row, the red box around 16.253% for % of Total was arrived at by using the following calculation:
108.6 / 668.17
where 668.17 is the combined sums of all the AUD Card Types On Promotion.
(2) In the fifth row, the red box around for 100% for % of Total was arrived at by summing all of the percentages for Currency Code AUD's Card Types
(3) In the Grand Total row at the bottom of the Bib-Shorts On Promotion column, the 100% was arrived at because 845.83 is 100% of all Bib-Shorts On Promotion for all Currency Codes and Card Types.
(4) In the Bike Racks Price column, the red box around 9.998% was arrived at using the following calculation:
10.95 / 109.52
where 109.52 is the sum of all Bike Racks Price of Currency Code CAD for all Card Types.
(5) The value 2859.58 is the sum of every row's SUM(Freight) value, and therefore 100% of SUM(Freight) for the entire table.
% From Previous - Table Across - Range: All Anchor % From Previous % From Previous
...
(1) In the first row, the red box around 13.821% for % Difference in SUM(Freight) was arrived at by using the following calculation:
15.01 / 108.6 = 13.821%
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 76.982% was arrived at by using the following calculation:
514.37 / 668.17 = 76.982%
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 0% was arrived at by using the following calculation:
0 / 9.21 = 0%
where 9.21 is the SUM(Freight) of all Bib-Shorts/Price for Currency Code CAD and Card Type Distinguish.
(4) In the final row within Bike Racks/On Promotion column, the red box around 211.377% was arrived at by using the following calculation:
1138.71 / 538.71 = 211.377%
where 538.71 is the SUM(Freight) for the previous item (Bib-Shorts/Price for all Currency Codes and all Card Types).
Difference From Previous - Summarize Values from [selected dimension: Sales Reason] Range [selected dimension: Product Category] Anchor Difference from Previous Difference from Previous
...