How to ignore the dimension in a table

[Kevinchinese]

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.

[Channa · Accepted solution]

do with AGGR()

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

[jonathandienst]

>>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)

[Nishanthi]

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.

[Kevinchinese]

Thank you very much, I will do the test.

[Kevinchinese]

this expression is working. Thanks again 🙂

[lmartint]

Thanks 🙂 it helps me a lot