行列交叉（Queue crossing）.doc

行列交叉（Queue crossing） Tables, rows, columns, transitions, and cross queries are classic What is a cross chart? A cross table object is a grid that returns values based on specified conditions. Data is displayed in the compressed rows and columns. This format is easy to compare data and identify trends. It is made up of three elements: Thats ok column Summary field The rows in the cross table extend along the horizontal direction (from side to side). In the example above, Gloves is a line. The columns in the cross table extend vertically (up and down). In the example above, USA is a list. The summary field is at the intersection of rows and columns. The value at each intersection represents the sum (summing, counting, etc.) of the records that satisfy both the line conditions and the column conditions. In the example above, the gloves and the American Cross have a value of four, which is the quantity of gloves sold in the United states. A cross table can also include several totals: The end of each line is the total of the row. In the above example, the total represents sales of a product in all countries / regions. The value at the end of the glove line is 8, which is the total number of gloves sold in all countries / regions. Note: a total column can appear at the beginning of each row. The bottom of each column is the total of the column. In the above example, the total represents sales of all products in one country / region. The bottom of a column in the United States is four, which is the total number of all products (gloves, belts, and shoes) sold in the United states. Note: a total column can appear at the top of each row. The total (Total) column (total product) and the total (Total) line (national / regional total) intersect at the total. In the above example, the value of the total column and the total line intersection is 12, which is the total number of all products sold in all countries / regions. Two, row column conversion and cross search: 1: column to