Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I have a similar issue as explained in this post.
If I use to formula from @swuehl to compute my annual revenues:
aggr(rangesum(sum(monthlyRevenues)),year)
I end up with this:
Year | Product | Stock | Annual revenue |
2016 | A | 2 | 2858 |
2017 | A | 13 | - |
2017 | B | 2 | 9837 |
2018 | A | 12 | - |
2018 | B | 2 | - |
2018 | C | 2 | 14753 |
How to fill the blank cells with the annual revenues?
Thanks
It is a bit tricky without having a sample to work on. I suggest you to consider to post a sample qvw or a set of transaction data to your question and even in future questions in the community. If you do you will more likely get a more response to your question.
In this case it could be a simple fix to your expression. Try this:
aggr(NODISTINCT rangesum(sum(monthlyRevenues)),year)
-Vegar
can u share a sample qvw showing your porblem?
It is a bit tricky without having a sample to work on. I suggest you to consider to post a sample qvw or a set of transaction data to your question and even in future questions in the community. If you do you will more likely get a more response to your question.
In this case it could be a simple fix to your expression. Try this:
aggr(NODISTINCT rangesum(sum(monthlyRevenues)),year)
-Vegar
Thanks a lot @Vegar this is what I was looking for!
Usually I would have posted a data sample but I thought this question was simple enough for you to answer.
I guess I was right since you found the solution very quickly 😉