Report Design-Cross report-Multi-layer crossover

First, the new data source

Second, the Operation procedure

Fill in cell C1 =to (1,3) set to scale out

Fill in cell C2 =to (21,22) set to scale out

Fill in cell C3 =to (13,15) set to scale out

In cell A4, fill in the =to (11,13) setting to scale vertically

In cell B4, fill in the =to (31,33) setting to scale vertically

Fill =max (c1{}) in cell D1, and take the maximum value after cell expansion in C1

Fill in the D2 cell with =sum (c2{}), and the C2 cell expands

Fill in the D3 cell with =sum (c3{}), and the C3 cell expands

In cell C4, fill in the =A4*B4+C1*C2

In cell D4, fill in the =sum (c2[; c1:2,c2:2]{}), to find the displacement coordinate

Third, the report after the calculation of the preview

Cross-Extension:

The same report may have both vertical and horizontal extents, and if they have overlapping parts of the sublattices, then they have both Zolt and upper Main, and when expanded, they are copied down and to the right to form a rectangular range of cells, allowing cross-scaling.

Multilayer Crossover Extension:

When cross-scaling, if the scale-up or scale-out grid is a multi-tiered extension, multi-layer cross-scaling is achieved. When a cell is scaled horizontally, it will be larger on the top of the same column, copy its attached cells, and, in particular, will not be pulled larger if one of the main cells is not on the same column;

Report Design-Cross report-Multi-layer crossover