No totals when viewing in Excel
Created by: Gavin Hodge
Modified on: Mon, 7 May, 2018 at 9:55 AM
Spreadsheet reports are exported to Excel format when sent via email, and also when 'Save As Excel' is used while viewing a report.
When you first open an Excel attachment it will show in Protected Mode where formula cells are shown blank. To exit Protected Mode and enable formulas, click the Enable Editing button at the top of the window:
This step is required each time a new attachment is opened.
It is possible to disable Protected View in Excel, but this step should be taken with caution.
Report Designer Excel Style Formulas
Created by: Gavin Hodge Modified on: Fri, 14 Feb, 2020 at 9:43 AM Most formula transformations can be done using value source formulas, but the report designer tool also supports using literal Excel style formulas. While value source formulas are ...
Import an Excel file
Created by: Johann Du Toit Modified on: Tue, 3 Dec, 2019 at 12:46 PM How to Import Your Own Excel Data and use it to create a Report Note: This functionality is only available on Professional and Enterprise plans. Set up a Connector to Excel Click ...
How to decide when to use Value Source or Excel formulas?
Created by: Johann Du Toit Modified on: Fri, 14 Feb, 2020 at 9:41 AM Warning! This is a confusing subject, but please bear with us. If you've done some report designs and created formula columns, then you would be familiar with "Value Source" or ...
Created by: Gavin Hodge Modified on: Wed, 14 Feb, 2018 at 3:38 PM Executing reports is the core part of Wink Reports. This reference will cover changing filter values, exporting, using saved filters, parameter lists, and creating sharing URLs. The ...
Designing a conversion rate report
Created by: Gavin Hodge Modified on: Tue, 18 Sep, 2018 at 2:06 PM A conversion rate report is one of the more advanced uses of the report designer. It requires use of many features of the designer including value formulas, Excel style formulas, ...