topic Re: Ignoring a dimension in a table in App Development

Ignoring a dimension in a table

max31 — Sat, 16 Nov 2024 04:10:09 GMT

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

Re: Ignoring a dimension in a table

Frank_Hartmann — Wed, 06 Nov 2019 10:39:47 GMT

can u share a sample qvw showing your porblem?

Re: Ignoring a dimension in a table

Vegar — Wed, 06 Nov 2019 11:09:51 GMT

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

Re: Ignoring a dimension in a table

max31 — Wed, 06 Nov 2019 13:21:23 GMT

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 😉