grids – XLCubed Blog

Chart-driven Table Highlighting

Toby Nash — Thu, 21 Oct 2021 09:19:37 +0000

Recently a customer raised a support issue asking if it was possible to highlight a row within a table based on a selection made in a chart. Interactive charting being a core XLCubed feature, of course it is! Here we can click on a country to highlight the relevant rows or we can go one […]

The post Chart-driven Table Highlighting appeared first on XLCubed Blog.

Custom Grid & Table Headers For Dynamic Sorting

Catherine France — Thu, 13 Feb 2020 13:37:41 +0000

Consider this simple grid. It shows a ranking of the top 10 products by Sales Amount. We are going to add our own headers to this grid allowing us to create our own column names as well as implement custom functionality for dynamic ranking. Creating Custom Headers First, we need to hide the grid’s current […]

The post Custom Grid & Table Headers For Dynamic Sorting appeared first on XLCubed Blog.

Grid Favourites

Catherine France — Fri, 17 Jan 2020 14:29:43 +0000

Do you ever find yourself creating the same grid over and over again? Sometimes we want to add the same grid multiple times but with a few variations, or in different workbooks. This can be especially tiresome if the grid has complex member selections or if the underlying data model has a large number of […]

The post Grid Favourites appeared first on XLCubed Blog.

Customer Segmentation By Revenue Contribution

Neerja Maudgil — Thu, 03 Oct 2019 09:45:34 +0000

We recently had a customer asking us for some assistance with a business challenge. He had been asked to provide a report analysing their customer base by % contribution to company revenue. But that wasn’t all! He also had to produce an additional report that tracked the customers ‘lost’ by the company Year on Year […]

The post Customer Segmentation By Revenue Contribution appeared first on XLCubed Blog.

Using Grid Styles in XLCubed

Neerja Maudgil — Wed, 14 Aug 2019 12:30:15 +0000

This week’s blog is a quick tip on Grid formatting options. Did you know that XLCubed comes with ten pre-formatted grid styles which you can easily switch between? These are available from the Workbook Format button on the XLCubed ribbon (the option remains greyed out until an XLCubed grid is added). Grid styles allow for […]

The post Using Grid Styles in XLCubed appeared first on XLCubed Blog.

Advanced Grid Reporting – MDX:

Colin Overton — Thu, 11 Apr 2019 09:58:01 +0000

This weeks blog is for the more technically minded among our user base and our partner network – not for everyone, but highlights some potentially very powerful capabilities! We will be looking at using MDX: and MDXSet: along with Query Generators to create sub-cubes, meaning we can develop advanced reports that would otherwise be difficult […]

The post Advanced Grid Reporting – MDX: appeared first on XLCubed Blog.