Conveniently remove blank item rows in your PivotTable reports

When creating reports, it’s usually preferred that rows with irrelevant data are excluded—as this results in a tidier, more readable report.  When it comes to PivotTable reports, this can include rows with blank items.  Below is an example of a report with them shown. To get rid of them, we have an add-in specifically for […]

Continue reading


How to enhance your Excel dashboards with Power View reports

Dashboards in Microsoft® Excel® are used for visually presenting important business information. Dashboards can display current status of metrics and key performance indicators. In this tip, we look at how to enhance dashboards with a Power View report by analyzing sales data. Power View reports in Microsoft® Excel® pull your data together in tables, matrices, […]

Continue reading


Midway Two makes the move to automated consolidation

As the holding company for seven subsidiaries, Midway Two’s monthly financial assignment includes the consolidation of its group’s results. In order to monitor the progress of the firm, each month end is a recipe of administrative man-hours, information processing and software tools in a race to output financials. Add a bit of the monthly unexpected, a touch of […]

Continue reading


The Sage Intelligence Reporting resources and learning you need, all in one place

To enable you to get going and make the most of our smart reporting solution, here’s a list of the helpful Sage Intelligence Reporting resources available in our resource library: You can engage with partners and customers right now on the Sage Intelligence Reporting Community. Download the one-page Kick-off guide specific to your accounting/BMS solution […]

Continue reading


More efficient report running: Part 2 – Using system variables with scheduled reports

In this tip, we continue from where we left off with the previous tip, and will demonstrate how you can use system variables when scheduling reports to run automatically. This will reinforce how they are applied during the scheduling process. If you didn’t catch the previous tip, you can find it here. There are many […]

Continue reading