topic How to ignore the dimension in a table in App Development

How to ignore the dimension in a table

Kevinchinese — Sat, 16 Nov 2024 20:41:14 GMT

Hello,

I have a table with "Brand", "Product" and "Country" are dimensions.

Two measures as below:

1. Sum({<Year={'$(vMaxYear)'}>}value) .... 'value' is a filed, 'vMaxyear' is a variable.

2. I need another expression to calculate the sum of value according to Brand and Product. I don't know how to write this expression, how to ignore the dimension with Country field.

Thank you for your help.

Re: How to ignore the dimension in a table

Channa — Wed, 12 Jun 2019 03:51:15 GMT

do with AGGR()

=Aggr(Sum({<Year={'$(vMaxYear)'}>}value) ,Brand,Product)

Re: How to ignore the dimension in a table

jonathandienst — Wed, 12 Jun 2019 05:08:22 GMT

>>1. Sum({<Year={'$(vMaxYear)'}>}value) .... 'value' is a filed, 'vMaxyear' is a variable.

Not sure what the question is here. You could probably lose the quote marks if vMaxYear is numeric.

>>2. I need another expression to calculate the sum of value according to Brand and Product....

Use a partial total:

=Sum({<Year = {'$(vMaxYear)'}>} TOTAL <Country> value)
or
=Sum({<Year = {$(vMaxYear)}>} TOTAL <Country> value)

Re: How to ignore the dimension in a table

Nishanthi — Wed, 12 Jun 2019 05:13:20 GMT

Sum(Total<Dimension>{<Year={'$(vMaxYear)'}>}value) can be used to ignore the particular dimension. If more than one dimension have to included you can do that with comma separated.

Re: How to ignore the dimension in a table

Kevinchinese — Wed, 12 Jun 2019 05:13:47 GMT

Thank you very much, I will do the test.

Re: How to ignore the dimension in a table

Kevinchinese — Wed, 12 Jun 2019 05:16:40 GMT

this expression is working. Thanks again 🙂

Re: How to ignore the dimension in a table

lmartint — Mon, 21 Jun 2021 16:41:23 GMT

Thanks 🙂 it helps me a lot