2 Replies Latest reply on Jun 15, 2018 6:09 AM by Li Ma

    How to automatic hide columns and keeping running total

    Li Ma

      I have a weekly new registrations. The request is to show the cumulative sum per week but only the last 4 weeks. I used the total sum in quick table calculation to the calculate cumulative sum. But if I filter out the last 4 weeks, it will only include last 4 weeks in cumulative sum. I still want to keep the whole from wk1 of this year.

      Is there a way to automatically hide the earlier weeks previous to the last 4 weeks? Or is there a way to default the horizontal scroll bar to the right?