With all of the spreadsheet data in a uniform cube, it’s easier than you think to slice the cube in any way.
In fact, it’s a snap
ExcelCube’s Cross Section feature works like a pivot table, except it works across workbook files. Any number of rows and columns can be retrieved from your files to instantly provide you with the information you need.
All of the information in each spreadsheet is available across all of the workbooks at every level – input or consolidated.
When the structure or underlying spreadsheets are changed, the cross section choices change automatically.
How Cross Section Reporting Works
Specifying a cross section is done by simply by checking the boxes corresponding to the rows, columns, and files in a structure.
These selections are stored and can be re-run at any time.
The rows, columns, and workbook files can then be sorted by each parameter, again by just pointing and clicking. The end result is a new Excel workbook containing the Cross Section data.