Brian Petersen
- Total activity 363
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 191
Articles
Recent activity by Brian Petersen-
Working with Charts and Graphs
Overview Charts and graphs are very useful tools within Excel for visually displaying information to users. They can make it easy to see comparisons between different values or to illustrate how la...
-
Inserting or Deleting Rows and Columns in Existing Range Lists
Overview When working with Range Lists it is common to need to insert additional rows or columns to accommodate additional information that needs to be added to the report. This article will cov...
-
Unsupported Excel Functions
Overview While Cosmos fully supports the vast majority of Excel functions, there are some Excel functions that are not currently 100% supported. Many of these are obscure of rarely used Excel funct...
-
How to Use PivotTables with Power BI Datasets
Overview PivotTables can be a very useful tool for ad hoc analysis. While the standard Cosmos Report Engine doesn't support PivotTables currently, it is still possible to use them in conjunction wi...
-
How to Preview a Report When Editing
Overview When a Report Editor is creating or making modifications to a report, it can be helpful to periodically run the report after making changes to ensure that the result is in line with what t...
-
Working with the Cosmos Excel Add-In Settings
Overview The Settings button in the Cosmos Excel Add-In provides the user with several settings to enable more control over the report authoring process. This article covers each of the available...
-
How to Exclude Closing Entries from a Report
Overview In Business Central, closing entries are posted at the end of the year to zero out income statement accounts. By default, when a report is created, it will sum up all the GL transactions t...
-
How to View Preview Diagnostics
Overview Preview Diagnostics provides a way for Report Editors to see what is happening when a preview of a report is running and to see error messages related to the report. This will help Report ...
-
How to Use Excel Links
Overview Excel Links provide a powerful way for users to leverage the full power of Excel to create custom filters that can then be used within their Cosmos functions. A popular user case for this ...
-
How to Reverse the Sign of a Sum Function
Overview There are certain instances where a user may want to reverse the sign (e.g. turn a negative number into a positive number or vice versa) of a sum function in a report. This article covers ...