ExcelBanter - OLAP - use CUBE functions to sort on the basis of underlying set

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - OLAP - use CUBE functions to sort on the basis of underlying set (https://www.excelbanter.com/excel-programming/402928-olap-use-cube-functions-sort-basis-underlying-set.html)

matekosor

OLAP - use CUBE functions to sort on the basis of underlying set

I have read about sorting a list retrieved from OLAP database based on member
values on msdn blog http://blogs.msdn.com/excel/archive/...06/526156.aspx
There a list of top customers based on bike sales in 2004 is created.

I would like to modify that example so that it returns the list of top
customers based on bike sales in 2003 and 2004 combined. How could this be
achieved?

All times are GMT +1. The time now is 06:14 PM.