1 Reply Latest reply on Jan 10, 2019 9:47 PM by sajad.bhat

    Rank by Running Total Table Calculation Issue by Product Name

    Wen Lin Kwek

      Hi All,

       

      I am having an issue with ranking by running total table calculation in my data set, will appreciate if anyone knows a workaround to this. 

      My worksheet is built such as then the user selects the time range, (Last Week, Month to Date, Quarter to Date), the worksheet will do a running total by Fiscal Week of Year (based on product name).

       

      I've replicated the issue on the sample superstore dataset, basically, I want to be able to rank the product name based on top sales (descending).

      I tried to rank them by Rank(Running_Sum(Sum([Sales]))) but this doesnt work, same issue with my worksheet that I am working on.

      Ranking Issue.JPG

      Best Regards

      Wen Lin