In this article you will learn how to configure your Sheet so that Awesome Table can work properly. We will see where you should put your headers, filters and parameters.
1 - First Row : the column headers
Use short descriptive name. The columns header will serve as filter title and chart headers.
2 - Second row : the data filters & parameters
Add a blank row below your header row (like the image above).
Note: Even if you don't use any filters, you must add the blank row.
Set your parameters and filters in the second row. The headers in the first row will be reused in the Awesome-Table view as titles for filters. Learn more about available filters and available keywords.If a cell contains 2 elements, separate those elements with a "-".
Do not hide the second row, as it will prevent Awesome-Table to correctly get the filters and parameters.