Agrr + above function not working as expected

[Anonymous]

Hi, I have a fill rate calculation based on first item >90% for cumulative ratio and then the immediate before.

I have a dummy data set with 2 columns Region and OrderTime, sorted by Region

When I create what I want in a table chart, it is just fine, the cumulative orders are ok so the ratio and finally the fillrate, for both regions available (AMs & EMEA)

AMS                                                                                                         EMEA

But as this is not the format I want, I'm re-creating the whole formula in a texbox to get to the final fillrate, it works ok for AMS only (as it is the first region sorted in raw data file) but when I filter EMEA the cumulaive sum is wrong (ONLY IN TEXT NOT TABLE). I i manually move EMEA to the top it works now for EMEA  but not AMS, if I mix the records none work.

AMS                                                  EMEA

<-----wrong cumulative, compare vs. table above

See files attached

[Anonymous · Accepted solution]

Hello,

in the attached qvw you can find a solution (pink text box).

In the script editor I changed you code, ordering records and assigning to them an ID (a progressive number): my script can be improved....

With this unique ID I think you can solve the problem: make some tests and let me know if it's correct for you.

Thanks and KR

Elena

[Anonymous]

Thanks a lot Elena!