1.- Output

You can only apply a Spider analysis to one output variable and several input variables.
In this example we choose the Net profit after tax output variable.
We will leave the default headings. Here we are using only the row heading, but not the column heading, which would have been 2006.

Important
Only headings with text format will be detected automatically.

The tool will detect the nearest heading to the selected cell, in terms of both rows and columns.

2.- Inputs
In this example, we are going to work with these inputs: Units, Price per unit and Cost per unit.

Important
By default, the toll will only take the values for 2006, rather than for all years.