Forum Discussion

laurya's avatar
laurya
Data Storage
10-24-2023

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 as expected.

However, when I add more fields (item name, etc.) the running sum values are not correct. I have also tried RSUM([Total net revenue],TRUE) but this does not work. 

Manufacturing

5 Replies

Replies have been turned off for this discussion
  • HamzaJ's avatar
    HamzaJ
    Data Integration
    10-25-2023

    Hey laurya 

    I dont fully understand what you mean. Could you perhaps post a screenshot with how it is and how you would like it to be?

     

    Hamza

  • laurya's avatar
    laurya
    Data Storage
    10-26-2023

    Hi, please see attached screenshots

     

     

    • HamzaJ's avatar
      HamzaJ
      Data Integration
      10-27-2023

      Hey,

      I am unable to reproduce it. Could you perhaps share the formulas that you have used? I will try to mimic this on my side. 

  • laurya's avatar
    laurya
    Data Storage
    10-27-2023

    Hi, the formula is RSUM(RSUM([Total net revenue]) for both widgets. I also tried RSUM([Total net revenue],TRUE)

  • vshen's avatar
    vshen
    Sisense Employee
    12-03-2023

    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