Dear All,
I have seen various examples on the sumproduct alternative where the criteria are constant indicated within the Quotes ("") for providing the results.
In my case i would like to calculate cumulative totals for each category ("Accrued expenses" etc). The cumulative is with reference to the Financial period indicated as (1 to 12). For some categories there are no posting in certain periods.
I have also provided the result if it is done in the case of normal excel using Sumproduct.
Looking for the similar solution in PowerPivot and PowerQuery, file attached.
Thanks in advance.
Bookmarks