This sample demonstrates how to maintain a shareholders register using a timeline to record various transactions among different shareholders on different types of shares.
The system feeds the closing balance of the shares to the opening balance of the next period.
We use the History dimension as a time scale to achieve the result.
The second cube 'Shareholders with %' demonstrates how to use of the Reference() function to calculated the holding of each shareholder relative to the total number shares from the same source cube.
We also use the row and column filters to hide empty rows or columns.