RSUM with multiple dimensions
Hi everyone, I am trying to create a running sum formula in a Pivot table. The formula is RSUM([Total net revenue )]). When I have 1 dimension in the Pivot table (item number), the formula works a...
Forum Discussion
Hi there!
Pivot is an aggregating widget, so unless specified otherwise, the calculation is for the smallest aggregation.
So it is expected that the RSUM([Total net revenue]) formula will only calculate a running sum for the last dimension in the Rows section of the pivot.
However, using RSUM([Total net revenue],TRUE) formula should provide you with the results you are looking for, as it accumulates the sum continuously in the case of 2 dimensions or more. I've tested it myself and got the desired results.
In case this doesn't work as expected, I suggest submitting a ticket for Support to look into this further. Thank you!
Best Regards,
Volodymyr
