The inXL Get Data option lets you return both actual and budget information for nominal accounts. You'll need a data connection set up for inXL first — see the Create a data connection for inXL article. Once the data connection is set up, follow the steps below.
In the Access InXL tab, click Get Data (left hand end of the ribbon)
Select the Dataset as required.
Choose the Period and Year.
Use Next to set Criteria.
When the Lookup Selector is opened for the item, it is necessary to click Display to return available values.
Use the Arrows to select/deselect items and then Select to save the options.
Click Next to select Nominal Attribute options in the same way as the criteria above.
Click Get Data to return the information to Excel.
The Data sheet shows the information returned.
ReportDefault offers the space to create reports based on it for example pivot tables or similar.