i have a pivot table with two dimensions, "month" and "year", and one expression ("sales"). i need to create another pivot table, similar to the original one, but on a cumulative basis: for example, month 2/12 will be the sum of sales of both 1/12 and 2/12. month 3/12 will be the sum of sales of 1/12, 2/12 and 3/12.... please see below:
You can achieve this using RangeSum(Above(Sum(Amount), ... ) as expression. See more in the blog post about Pareto analysis, where such an accumulation is used.
You can achieve this using RangeSum(Above(Sum(Amount), ... ) as expression. See more in the blog post about Pareto analysis, where such an accumulation is used.
.png "Former Employee"){kind=icon}