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”
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”
Did you know how easy it is to search for members within XLCubed?
Continue reading “Member Searching”
Most formatting in XLCubed can be handled though the formatting options available on the right-click menu, and today’s blog will cover some of the common use cases.
Continue reading “Grid Formatting 101”
Propagate across Sheets
Today’s blog will run through Propagate across Sheets – it’s an XLCubed feature that’s been around for some time but is definitely one of our hidden gems!
Propagate across Sheets is some great functionality that allows users to quickly replicate a report onto additional sheets within the same workbook or a new workbook.
Continue reading “Propagate across Sheets”