Here is a use case at work where the grand total of a table needs to be accumulated horizontally to the right.
In the table, daily sales are shown by categories. The expected result is as follows:
We will use customized grand total technique to calculate it. The formula is as follows:
Usually we use Min(Category)=Max(Category) as the conditional. However because of null values in Sales and table calculations for cumulative sums, that conditional doesn't work in this case.The demo workbook can be downloaded here.
Feel free to leave comments below or contact me at twitter @aleksoft.
Add a comment