IN THIS SEC


Overview


Joiin has a hard limit of the number of columns (Periods to Compare) that can be selected for a single report. This is in place to ensure the system is performant and that the report can be rendered in the UI usefully. If you need more than 60 columns though, there are strategies you can use to achieve this. This article outlines some of them.


The need to output a single report for display with more than 60 columns (5 years when broken down by month) is low - more likely is that the data is required for subsequent processing such as in Excel or in a BI tool. The strategies below take this into consideration.



Downloading to Excel

You can run multiple reports, download them to Excel and merge the results there.


TIP: We recommend that you switch the "Hide Zero Value Accounts" setting off in Report Settings so that all accounts will be included in all reports.


Report Packs

You can include multiple reports in a report pack. You can create sections with rows and columns and change the paper size to create the best layout for your pack. By including more than one report like this you can include the required data (more than 60 columns) but show it in a way that looks presentable.


Simply run one report, with less than 60 columns, e.g. for one or two years - then add that to a Report Pack using the Save button. Repeat for any additional columns, save the report to the same report pack. You can then go into the Report Pack via the Saved Reports and Packs menu and adjust the positioning and settings of the layout.


Alternatively start from a blank or existing report pack, and add reports directly into the pack from there.



Excel Add-In

The Excel Add-In is a powerful tool to work with Joiin data directly in Excel. With the Excel Add-In you can specify formulas like:


=JOIIN.TB({"Joiin Ltd"},"GBP","2024-12","2024-12")


By creating multiple columns in Excel, each with its own formula containing a desired dates, you can achieve an output with as many columns as required.