MicrosoftSense of achievement. Yesterday I reworked a multidimensional array challenge created by Paul Mireault and presented at EuSpRIG 2019.
The model assumes the units sold to be accounted as a function of the product, the region of sales, the client business sector and time. The 'standard' way of approaching the problem was to build a normalised data table, to use pivot tables for the analysis and extract results to a dashboard.
Using the new Lambda function, I have repeated the calculation but using a 4D array concept. The function
= UNITSALES( Product, Region, Sector, Month )
returns the result for any combination of parameters, up to two of which may be arrays. Naturally, the definition of the Lambda function depends on the underlying scheme adopted for the storage of the data, but my formula was
The required output included 2D tables
so I used recursion to sum over the 'Sector'.
So far, so good!
