Cross Section Reporting

Slicing Through Your Workbooks to see the Rows and Columns You Need

With all of the spreadsheet data in a uniform cube, you’d
think it would be easy 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.  

The ability to slice the data cube by any parameter is available with no additional setup. 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 choosing a spreadsheet and 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.