How to include all the values for rolling total inspite of Dimension limits

[varunreddy]

Hi All,

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.

For example:

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!

Cheers,

Varun

[sunny_talwar]

Would you be able to attach the test file?

[varunreddy]

Attached

[sunny_talwar]

The attached app doesn't have the charts

[varunreddy]

Sorry. Added

[sunny_talwar]

Use if statement with rank rather than using dimension limits

[varunreddy]

Hi Sunny,

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.

[sunny_talwar · Accepted solution]

What is the problem my friend?

You might have forgot to change the dimension from Test to Week...

[varunreddy]

Yeah. I didn't change the dimension. Thanks Again. Sorry for the confusion