In DataTile, you can generate several crosstabs containing a similar request with a single action. Each new table is saved on a separate tab and all of them can be downloaded at once.
Users can effortlessly replicate as many tables as necessary by altering rows with different variables, or vice versa.
How to iterate tabs with requests:
Build the original table with the query. Name the tab on which it is placed;
Select all the variables that are to become replacements when iterating, then drag&drop them onto the header of the existing tab.
A dialog box appears; choose either "fix columns, iterate rows" or "fix rows, iterate columns". Here 'fix’ means to keep the same, whilst ‘iterate’ means change/replace.
Each new table will be instantly generated and saved as an individual tab.
Open saved tabs by clicking the 'hamburger' icon
. To export all the tables to PowerPoint or Excel, click the ‘Download All’ icon
.
Watch the short video below for a demonstration of these instructions: