I am trying to calculate running total. Running sum along with above works fine for small dataset, but for large dataset it errors out for straight table. There are more than 14 dimensions in straight column. Can someone please help me to solve this issue.
Current expression : RangeSum(Above(TOTAL Count({<Set Exp>} [Column])0,RowNo(TOTAL)))
hi @Prashanth_812 I never experienced any issue with a Rangesum function for large datasets. Would you mind sharing your rangesum complete script and possibly some dummy data?
Thanks for your reply . Please find the attached file. It works well for small dataset, but when I use TOTAL identifier along with Rangesum it errors out with Timeout issue.
