You can create complex reports with Qvinci. There may be times when you would like to enter data in different tabs and reference those tabs in your reporting results.
Cross-referencing is done in the same worksheet or in different worksheets in the same file.
Cross-Sheet Referencing in Report Styler
To accomplish this, a cell is named using a column using letters and a row using numbers.
When a multi-tab report is created in the Report Styler, it is oftentimes necessary to use cross-sheet referencing. The format for cross-sheet referencing is similar to that of Excel.
You will reference the sheet name, followed by the column and row, or use a range of columns and rows.
If you're using a data tab that you do not want to see in the completed report, name that tab with # in front to keep it hidden and also to not print.
Using the BI-KPI SC Mutli-Entity - FYTD v PFYD +% (S) as an example, we can see multiple hidden data tabs at the bottom.
In this report, we reference cells in these data tabs to produce the results we want to see.
Cell Formula: ='Sheet Name'!Cell
This would be used if you wanted to reference a single cell value in your report.
Range Formula: ='Sheet Name'!Cell:Cell
This would be used if you wanted to include a range of cell values in your report.
We're More Than Happy to Help
Schedule a call with Customer Success below, email us at email@example.com or call us at 1-512-637-7337 Ext. 1 Available M-F, 7:30am-6:30pm CT and it is always FREE!