RSUM

Question

Hi

I am trying to create a report as the one in the image below, revenue week over week by region, if we notice the revenue is running sum.

Now if I create it and show it by week as the image below it works fine

The minute I add region or product the numbers start to not make sense. the question is how come? thank you .

Joe Choueiri-Oracle · Answer

I redid it from the beginning and it worked, thank you @Gianni Ceresa

Gianni Ceresa · Answer

The good new is the formula looks good, the bad news is that your analysis/model is weird

As you can see with a normal model and a normal analysis it just works fine. As yours isn't working at all ... there must be something weird...

Can you look at the generated query (logical and physical) to find out what's going wrong?

Joe Choueiri-Oracle · Answer

Thanks @Gianni Ceresa

I tried that but it did not work...do I have it wrong? here is the image of my formula

But then I ended up with this