Announcements
cancel
Showing results for
Did you mean:
Contributor II

## How to ignore the dimension in a table

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.

Labels (1)
• ### Ignore dimension

1 Solution

Accepted Solutions
Specialist III

do with AGGR()

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

Channa
6 Replies
Specialist III

do with AGGR()

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

Channa
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Contributor II

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.

Contributor II
Author
Thank you very much, I will do the test.
Contributor II
Author
this expression is working. Thanks again 🙂
Contributor

Thanks 🙂 it helps me a lot