Customer Segmentation XLCubed blog header

Customer Segmentation By Revenue Contribution

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 by looking at sales activity.

This approach is also often used when looking at profitability, and many businesses like to classify their customers in this way:

  • group ‘a’ of key customers make up 40% of our company revenue and group ‘b’ make up the next 30%
  • which customers have we ‘lost’ or have become inactive over a period

This is where XLCubed’s capability and flexibility comes into play – we have an advanced selection mode for handling exactly this type of scenario.

Continue reading “Customer Segmentation By Revenue Contribution”

Workbook format in XLCubed ribbon

Using Grid Styles in XLCubed

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).

Continue reading “Using Grid Styles in XLCubed”

XLCubed showing an element we wish to remove an update the totals

Advanced Grid Reporting – MDX:

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 to achieve.

Continue reading “Advanced Grid Reporting – MDX:”