Ignoring a dimension in a table

[max31]

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

[Frank_Hartmann]

can u share a sample qvw showing your porblem?

[Vegar · Accepted solution]

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 

[max31]

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 😉