How to Build a Range from Scratch

This article will show you how to build a range within Excel or Google Sheets in order to fetch your data.

Building Your Range

1. Open the Cube add-on within Excel or Google Sheets
2. Click the 'New' button under the Build section
3. Drag your dimensions into either the 'Columns' or 'Rows' sections
   
   In the clip below, 'Time: Q1-20' is being set as the Column header and 'Account: Income Statement' is being set as the Row header.
   
   
   
4. Click the 'Add Remaining Dimensions' button to bring your remaining filters down
   Note: If dimensions are not allocated properly, the 'Add Remaining Dimensions' will not be clickable
   
   
5. Click the 'Fetch Data' button to build your range and fetch your data

Looking to build a multi-dimension range?