I am trying to perform the rangesum function. I have values from 1 to 10 and I am trying to perform rolling sum. I am getting the data as desired. But when I try to choose top 5, my rolling sum is changing.
I am trying to see if we can do top 5 with all the values included in the rolling sum.
In below screen shot, In left report my range sum is working fine.
In right report, I am trying to display top 5. Here numbers are changing. Is there a way I show top 5 and numbers doesn't change?
Thanks in advance!
Thanks for the quick turn around. This seems to be working fine.
This is not working as expected as I have different scenario. My bad, I mocked up wrong scenario.
I actually have one dimension Week and one metric Data.
I am trying to get top 5 weeks using rangesum for the data. I am attaching new data set with the QVW.
Please take a look.